Is it possible to do a countif using the same cell reference for every
worksheet?

Like a Shorthand of doing
=COUNTIF(Sheet2!A1,1)+COUNTIF(Sheet3!A1,1)...+COUN TIF(Sheet15!A1,1)

Thanks in advance
Kieran


--
kmh987
------------------------------------------------------------------------
kmh987's Profile: http://www.excelforum.com/member.php...o&userid=33533
View this thread: http://www.excelforum.com/showthread...hreadid=533240