3 criteria
I have the following formula for adding numbers that match two criteria that works fine
=SUMPRODUCT(--($E$125:$E$1084=AM4),--($AS$125:$AS$1084="yes"),$K$125:$K$1084)
I want to add a third criteria so I did this:
=SUMPRODUCT(--($E$125:$E$1084=AM4),--($E$125:$E$1084=AM34),--($AS$125:$AS$1084="yes"),$K$125:$K$1084)
and now the formula result is always 0
How can I add a third criteria to be checked before adding the matches in column K?
Thanks
MB
|