Hi, what am I doing wrong with the following formula:

=countif(sheet1:sheet31!E6:E35,"=1")

FOR some reason this formula fails when I use the (sheet1:sheet31) with
the column range (E6:E35).

Is it possible to include a multiple sheet count and column range in
the same Formula? Thanks for any helpful responses..

By the way, the formula works ok just as long as I'm not trying to read
multiple sheets.. Please help on this.


--
Mhz
------------------------------------------------------------------------
Mhz's Profile: http://www.excelforum.com/member.php...o&userid=35980
View this thread: http://www.excelforum.com/showthread...hreadid=558346