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")

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")