| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
AutoSum Help
Hello,
I have a workbook with 5 worksheets in it. I would like to autosum say cel H3 on sheet 5 and be able to total cell H5 from sheets 1-4. Can I do that? Thanks!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
AutoSum Help
=SUM(Sheet1:Sheet4!H3)
"Stockwell43" wrote: Hello, I have a workbook with 5 worksheets in it. I would like to autosum say cel H3 on sheet 5 and be able to total cell H5 from sheets 1-4. Can I do that? Thanks!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
AutoSum Help
Thank you Barb, worked like a charm!!! I appreciate your help!
"Barb Reinhardt" wrote: =SUM(Sheet1:Sheet4!H3) "Stockwell43" wrote: Hello, I have a workbook with 5 worksheets in it. I would like to autosum say cel H3 on sheet 5 and be able to total cell H5 from sheets 1-4. Can I do that? Thanks!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i set up autosum as a % | Excel Worksheet Functions | |||
| autosum | Excel Worksheet Functions | |||
| AutoSum | Excel Worksheet Functions | |||
| AutoSum | Excel Worksheet Functions | |||
| autosum ?? | Excel Worksheet Functions | |||
Linear Mode
