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!