On Tue, 31 May 2005 16:10:23 -0700, "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

Download and install the free morefunc.xls add-in by Laurent Longre from
http://xcell05.free.fr/ and use the COUNTIF.3D function.


--ron