count cells over multiple sheets

Have three columns R,S,T · Dec 18, 2004

I have multiple, identical laidout, sheets in my book.
I would like to count the total number of cells, for say line 2, from each
sheet, that isn't blank.

Any ideas??

Thanks

DL

Frank Kabel · Dec 18, 2004

Hi
how are your sheets named exactly?

Domenic · Dec 18, 2004

Try...

=COUNTA(Sheet1:Sheet3!2:2)

Hope this helps!

"Have three columns R,S,T"

Have three columns R,S,T · Dec 18, 2004

Shhet1, sheet2, sheet3 etc
Thanks

Frank Kabel said:
Hi
how are your sheets named exactly?

Frank Kabel · Dec 18, 2004

Hi
use Domenic's suggestion for non blanks:
=COUNTA('first_sheet:last_sheet'!A2:X2)