count cells over multiple sheets
 

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

Hi
how are your sheets named exactly?

--
Regards
Frank Kabel
Frankfurt, Germany

Have three columns R,S,T wrote:
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

Try...

=COUNTA(Sheet1:Sheet3!2:2)

Hope this helps!

In article ,
"Have three columns R,S,T"
wrote:

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

Shhet1, sheet2, sheet3 etc
Thanks

"Frank Kabel" wrote:

Hi
how are your sheets named exactly?

--
Regards
Frank Kabel
Frankfurt, Germany

Have three columns R,S,T wrote:
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

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

--
Regards
Frank Kabel
Frankfurt, Germany

Have three columns R,S,T wrote:
Shhet1, sheet2, sheet3 etc
Thanks

"Frank Kabel" wrote:

Hi
how are your sheets named exactly?

--
Regards
Frank Kabel
Frankfurt, Germany

Have three columns R,S,T wrote:
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