Sum Total in a worksheet
 

I create 21 worksheet in a file name A,B,C,D.........'Total'
I want to sum all A1 cells of A,B,C.........in to cell A1of 'total' sheet

Cell A1 of 'total' is (=A!A1+B!A1+C!A1...........)

Is there any smarter way to sum all of it??
Thanks!

Sum Total in a worksheet
 

=SUM(A:C!A1)

--

Vasant


"man-man" wrote in message
...
I create 21 worksheet in a file name A,B,C,D.........'Total'
I want to sum all A1 cells of A,B,C.........in to cell A1of 'total'
sheet

Cell A1 of 'total' is (=A!A1+B!A1+C!A1...........)

Is there any smarter way to sum all of it??
Thanks!

Sum Total in a worksheet
 

Thanks!

"Vasant Nanavati" <vasantn *AT* aol *DOT* com ¦b¶l¥ó
¤¤¼¶¼g...
=SUM(A:C!A1)

--

Vasant


"man-man" wrote in message
...
I create 21 worksheet in a file name A,B,C,D.........'Total'
I want to sum all A1 cells of A,B,C.........in to cell A1of 'total'
sheet

Cell A1 of 'total' is (=A!A1+B!A1+C!A1...........)

Is there any smarter way to sum all of it??
Thanks!