Dear Excel(lent) users,

I am keeping track of questions I pose in my organisation in an excel sheet.
The header consists of
A: Date of entry
B: What is the question
C: Whom did I ask
D: Did I get an answer
E: When was it answered
F: Duration (which is subtracting A1 from F1)
G: Sort of question
H: Satisfied with answer

I have a seperate tab in the same file with statistics. Tab I have the names
of the person I have posed questions to in Column A.
Now I want to know the following:
How many times did that person answer my questions (Based on the name in C
and on whether D has the entry "Yes".
I tried
=countif(and('Data!'$c$2:$c$10='Statistics!'A1;'Da ta!'$d$2:$d$10="yes"), but
that doesnot work.

Please help me !! If need be, I can send the file to you, but it is in Dutch
format and formulas.

Thanks !!
--
** Fool on the hill **