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
Bookmarks