SUMPRODUCT problems

losing the will to live on this one, probably because it is another simple problem I can't solve

What I'm trying to do is search a range of cells for a range of values AND then see if it matches one other value in another range of cells.

In this case,

=SUMPRODUCT((T3:T49="P6")+(T3:T49="P5")+(T3:T49="P4")+(T3:T49="P3"))*(U3:U49="w")

T3:T49 can equal P6 or P5 or P4 or P3 but the cells can only be counted if U3:U49 is 'w' as well

Thanks for your help

You are closing the Sumproduct before the search in column U...

Try:

=SUMPRODUCT(((T3:T49="P6")+(T3:T49="P5")+(T3:T49="P4")+(T3:T49="P3"))*(U3:U49="w")

add another open paranthesis at the front end to enclose the + conditions.

or shorter

=SUMPRODUCT(--ISNUMBER(MATCH(T3:T49,{"P6","P5","P4","P3"},0))*(U3:U49="w"))

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save