Thread: 3 criteria
View Single Post
  #1   Report Post  
Mike B Mike B is offline
Junior Member
 
Posts: 7
Default 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