| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I count in column A when it meets all criteria in three col
Here's my example:
Column A Column B Column C 2 North Donna 09/26/06 3 South Abby 4 North Donna 5 North Donna 6 North Abby 7 North Cindy 09/01/06 I want to count column A when column C is blank, column B is Donna, and column is North. The answer would be two (2). Any help would be great! Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I count in column A when it meets all criteria in three col
=SUMPRODUCT(--(C1:C6=""),--(B1:B6="Donna"),--(A1:A6="North"))
-- Allllen "dereksmom" wrote: Here's my example: Col A Col B Col C 2 North Donna 09/26/06 3 South Abby 4 North Donna 5 North Donna 6 North Abby 7 North Cindy 09/01/06 I want to count column A when column C is blank, column B is Donna, and column is North. The answer would be two (2). Any help would be great! Thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I count in column A when it meets all criteria in three col
Try...
=SUMPRODUCT(--(A2:A7="North"),--(B2:B7="Donna"),--(C2:C7="")) Hope this helps! In article , dereksmom wrote: Here's my example: Column A Column B Column C 2 North Donna 09/26/06 3 South Abby 4 North Donna 5 North Donna 6 North Abby 7 North Cindy 09/01/06 I want to count column A when column C is blank, column B is Donna, and column is North. The answer would be two (2). Any help would be great! Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
| Lookup Table Dilemma | Excel Worksheet Functions | |||
| how can i count a number that meets a criteria? | Excel Worksheet Functions | |||
| Count rows based on multiple criteria | Excel Worksheet Functions | |||
Linear Mode
