| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add total items in from another worksheet? | Excel Worksheet Functions | |||
| i need to total weights on a worksheet | Excel Worksheet Functions | |||
| Summary total from another worksheet? | Excel Worksheet Functions | |||
| Possible? If total in a worksheet 0, highlight worksheet tab? | Excel Worksheet Functions | |||
| Get the total no. of worksheet & their name | Excel Programming | |||
Linear Mode
