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 **

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

HTH
--
AP

"Jaydubs" a écrit dans le message de
news: ...
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 **

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:

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 **

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
--
** Fool on the hill **


"Marcelo" wrote:

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:

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 **

Does this count as one of your questions, then?

Pete

Jaydubs wrote:
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
--
** Fool on the hill **


"Marcelo" wrote:

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:

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 **

What do you mean pete, I am not sure I understand your question, sorry !
--
** Fool on the hill **


"Pete_UK" wrote:

Does this count as one of your questions, then?

Pete

Jaydubs wrote:
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
--
** Fool on the hill **


"Marcelo" wrote:

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:

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 **