Count based on multiple criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've done this before but I can't find the file where it was done. I want a
count based on any column that has a value of "A" and any column that has a
value of "B". Any guidance would be appreciated. Thanks
 
What does any mean?

=SUMPRODUCT(--(A2:A10000="A"),--(B2:B10000="B"))


will count where A2:A10000 is A and B2:B10000 is B


--


Regards,


Peo Sjoblom
 
Back
Top