ExcelBanter - Count based on multiple criteria

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Count based on multiple criteria (https://www.excelbanter.com/excel-worksheet-functions/161453-count-based-multiple-criteria.html)

JerryS

Count based on multiple criteria

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
--
JerryS

Peo Sjoblom

Count based on multiple criteria

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

"JerryS" wrote in message
...
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
--
JerryS

All times are GMT +1. The time now is 06:54 AM.