| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#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 | |
|
|
Similar Threads
|
||||
| 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) | |||
Linear Mode
