| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CountIf with multiple conditions
This is similar to other posts, but those posts weren't solved so...
I have a worksheet with (among other columns) a company column, and a track column. I just want to count the records where the company is something specific AND the track is something specific. I can only seem to count one or the other. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CountIf with multiple conditions
Use SUMPRODUCT.
See here for details: http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- Brevity is the soul of wit. "Thor" wrote: This is similar to other posts, but those posts weren't solved so... I have a worksheet with (among other columns) a company column, and a track column. I just want to count the records where the company is something specific AND the track is something specific. I can only seem to count one or the other. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CountIf with multiple conditions
You might also want to take a look at the DCOUNT function.
"Dave F" wrote: Use SUMPRODUCT. See here for details: http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- Brevity is the soul of wit. "Thor" wrote: This is similar to other posts, but those posts weren't solved so... I have a worksheet with (among other columns) a company column, and a track column. I just want to count the records where the company is something specific AND the track is something specific. I can only seem to count one or the other. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF and multiple conditions | Excel Worksheet Functions | |||
| Formula for multiple conditions | Excel Discussion (Misc queries) | |||
| How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions | |||
| Sum If Multiple Conditions | Excel Worksheet Functions | |||
| COUNTIF using multiple conditions? | New Users to Excel | |||
Linear Mode
