Counting cells that meet 2 differnet criteria

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.


--
Regards,
Dave


"USChad" wrote:

> 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