ExcelBanter - Counting cells that meet 2 differnet criteria

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

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

- - Counting cells that meet 2 differnet criteria (https://www.excelbanter.com/excel-worksheet-functions/44311-counting-cells-meet-2-differnet-criteria.html)

USChad

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

David Billigmeier

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

All times are GMT +1. The time now is 05:40 PM.