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