Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting the number of cells meeting conditional formating criteria | Excel Worksheet Functions | |||
copying cells based on criteria | Excel Worksheet Functions | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Print cells that meet conditional formatting criteria | Excel Discussion (Misc queries) | |||
Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) |