Hi,

This is a bit long winded for all those sheets but I don't know of any other
way without resorting to a macro, perhaps someone else does.

Make a list of all the sheets in a column then select that list and

Insert|name|Define and call it (say) Sheets

Then enter this formula
=SUMPRODUCT(COUNTIF(INDIRECT("'"&sheets&"'!B43")," Yes"))

Mike

"tgcali" wrote:

Hello,

I have a workbook with 235+ pages and counting. The pages are named Sheet1,
Sheet2, etc. to keep it simple.

I need to know how to find out if the word 'yes' was entered into the same
specific cell (B43) on each sheet and have the total number of times this
occured show on my summary sheet, automatically updating as data is entered
and new sheets are created. Is this possible?

Thank you,

tgcali