JKwan
10-29-2012, 02:55 PM
I currently have this formula
=SUMPRODUCT(--(A1:A40="Marcellous")*(B1:B40="High Level"))
it isn't giving me quite the number that I want.
what I need the formula to do is look within column B where it contains "High Level". So far, I am failing....
It would be nice if this works
=SUMPRODUCT(--(A1:A40="Marcellous")*(B1:B40 Like "*High Level*"))
Hope someone can come up with a formula, thanks
=SUMPRODUCT(--(A1:A40="Marcellous")*(B1:B40="High Level"))
it isn't giving me quite the number that I want.
what I need the formula to do is look within column B where it contains "High Level". So far, I am failing....
It would be nice if this works
=SUMPRODUCT(--(A1:A40="Marcellous")*(B1:B40 Like "*High Level*"))
Hope someone can come up with a formula, thanks