It can be somewhat complicated if you have a lot of sheets.

List your sheet names in a range of cells. Assume this list is in the range
G1:G10.

=SUMPRODUCT(COUNTIF(INDIRECT("'"&G1:G10&"'!A24")," Y"))

It might be easier to just use another cell (the same cell) on each sheet
with this formula:

=--(A24="Y")

Then just use a sum formula like this:

=SUM(Sheet1:Sheet10!A1)

--
Biff
Microsoft Excel MVP


"Joan" wrote in message
...
I am trying to count values in a specific cell on multiple worksheets. (The
cell is in the same location on all the worksheets). Something like this:
Count all values = to "Y" in cell A24 on all worksheets.

Anyone have any suggestions?