Counting cells that meet 2 differnet criteria

U

USChad

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
 
D

David Billigmeier

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