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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count Distinct Values based on criteria 4
Count rows based on multiple criteria 3
Access Dcount (multiple criteria) 3
Determine Value based on criteria 1
Count columns that meet criterias 3
Counting based on multiple criteria 8
Counting number of rows based on mutiple criteria 2
Counting multiple criteria across columns and rows??? 1

Back
Top