| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count based on multiple criteria
I've done this before but I can't find the file where it was done. I want a
count based on any column that has a value of "A" and any column that has a value of "B". Any guidance would be appreciated. Thanks -- JerryS |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count based on multiple criteria
What does any mean?
=SUMPRODUCT(--(A2:A10000="A"),--(B2:B10000="B")) will count where A2:A10000 is A and B2:B10000 is B -- Regards, Peo Sjoblom "JerryS" wrote in message ... I've done this before but I can't find the file where it was done. I want a count based on any column that has a value of "A" and any column that has a value of "B". Any guidance would be appreciated. Thanks -- JerryS |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get the count in excel based on criteria in multiple col | Excel Worksheet Functions | |||
| Count unique values based on multiple criteria | Excel Discussion (Misc queries) | |||
| count based on multiple date criteria | Excel Worksheet Functions | |||
| how do i count values based on multiple criteria | Excel Worksheet Functions | |||
| Count rows based on multiple criteria | Excel Worksheet Functions | |||
Linear Mode
