Here is a workaround

http://tinyurl.com/97psj



Regards,

Peo Sjoblom

"Steve" wrote:

On my summary page of a multiple worksheet work book I want to count tihe
number of "Y" responses in the same cell across the entire workbook. I have
tried countif(worksheet1:worksheetend!C6,"Y") and it doesn't work.... any
help out there?

Thanks,

Steve