Counting cells that meet 2 differnet criteria

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

Guest

I need the number of cells in a database that meet two differnt criteria.
First it has to have a certain number in column A....such as 372647...then it
has to have certain data in column F... such as "NON CUSTOMER".. i have tried
several different formulas and nothing seems to be coming up correct for me.
Any help is appreachiated.

Thanks
 
SUMPRODUCT(--(A1:A10000=372647),--(F1:F10000="NON CUSTOMER")
Just change the row numbers to fit your data.
 

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 cells in a table that meet multiple criteria 1
Counting unique text that meets several criteria 10
Counting rows that meet multiple criteria 5
Counting cells with multiple criteria 3
Count IF 6
Counting Multiple Records by specific criteria 5
Count if if 1
CountIf previous cell formula 0

Back
Top