counting across several worksheets help needed please

[debbyes]

I need to do a count over several worksheets in the same workbook.
For example:

cell D15 on sheet 12 needs to be the total of the number of "y" in cell D15 on sheets 1-10, cell E15 on sheet 12 needs to be the total of the number of "n" in cell E15 on sheets 1-10.

I've tried countif, but that hasn't worked. I've tried sum and sumproduct without luck.

Anyone help please??

Thank you!

[Domenic]

Try the following...

Sheet12!D15:

=SUMPRODUCT(COUNTIF(INDIRECT("'"&$A$1:$A$10&"'!D15"),"y"))

Sheet12!E15:

=SUMPRODUCT(COUNTIF(INDIRECT("'"&$A$1:$A$10&"'!E15"),"n"))

...where A1:A10 contain your sheet names.

Hope this helps!

I need to do a count over several worksheets in the same workbook.
For example:

cell D15 on sheet 12 needs to be the total of the number of "y" in cell D15 on sheets 1-10, cell E15 on sheet 12 needs to be the total of the number of "n" in cell E15 on sheets 1-10.

I've tried countif, but that hasn't worked. I've tried sum and sumproduct without luck.

Anyone help please??

Thank you!

[debbyes]

That was a help!