Keeping status on posed questions in Excel

[Jaydubs]

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;'Data!'$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 !!

 

[Marcelo]

Hi Jaydubs,

try to use Sumproduct to solve it as:

=sumproduct(--($c$2:$c$10=Statistics!A1),--($d$2:$d$10="yes"))

Hope this helps
Regards from Brazil
Marcelo

"Jaydubs" escreveu:

 

[Ardus Petus]

=SUMPRODUCT((Data!C2:C10=Statistics!A$1)*(Data!D210="yes"))

HTH

 

[Jaydubs]

Great Thanks Marcelo and Ardus Petus,

I have used yours Marcelo and did not try yours Ardus. Thanks for answering
me both of you !!

Great stuff

 

[Pete_UK]

Does this count as one of your questions, then?

Pete

 

[Jaydubs]

What do you mean pete, I am not sure I understand your question, sorry !