PDA

View Full Version : Solved: Counting with SumProduct



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

mancubus
10-29-2012, 03:38 PM
perhaps

=SUMPRODUCT(--(A1:A40="Marcellous"),--(B1:B40="*High Level*"))

JKwan
10-30-2012, 05:57 AM
Thank you for the help, unfortunately, it did not work. However, I searched hi and lo, I found my solution:
=SUMPRODUCT(--(ISNUMBER(SEARCH("High Level",B1:B20)))*(A1:A20="Marcellous"))