| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
the total number of "Very Satisfied" questions there are
I am trying to check if the cells in A1 through A210 equals ADMISSIONS AUTH &
TRANSFERS and if the department question equals Very Satisfied in one worksheet so that I can add the total number of "Very Satisfied" questions there are. Is this the right way to do this? =COUNTIF('FW FILE DUMP'!A1:A210,A2) AND 'FW FILE DUMP'!C1:C209,DEPARTMENTS!A52 =COUNTIF('FW FILE DUMP'!A1:A210,A2) & ('FW FILE DUMP'!C1:C209,"Very Satisfied") |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
the total number of "Very Satisfied" questions there are
I think you need to use SUMPRODUCT.
Look at this: http://www.xldynamic.com/source/xld.SUMPRODUCT.html Dave -- Brevity is the soul of wit. "YouthHelp" wrote: I am trying to check if the cells in A1 through A210 equals ADMISSIONS AUTH & TRANSFERS and if the department question equals Very Satisfied in one worksheet so that I can add the total number of "Very Satisfied" questions there are. Is this the right way to do this? =COUNTIF('FW FILE DUMP'!A1:A210,A2) AND 'FW FILE DUMP'!C1:C209,DEPARTMENTS!A52 =COUNTIF('FW FILE DUMP'!A1:A210,A2) & ('FW FILE DUMP'!C1:C209,"Very Satisfied") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table for reporting sales performance | Excel Discussion (Misc queries) | |||
| Total Questions | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
| Total number of each month in a column of dates | Excel Worksheet Functions | |||
| Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions | |||
Linear Mode
