Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Adding cells from multiple Worksheets
Good day,
I am looking for a way to add cells together from multiple worksheets within a single spreadsheet. The catch is: I want to be able to create the formula to allow me to insert additional worksheets and still come up with the correct total. Is there a way to reference a cell in a non-existent worksheet? Or is there another way to accomplish my goal? TIA - Joe |
#2
|
|||
|
|||
Hi Joe
Add two dummy sheets(empty sheets)with the name start as the first sheet and one with the name end as the last sheet of your workbook. this are empty sheets!!! All worksheets between these sheets will be Sum with this formula =SUM(start:end!A1) -- Regards Ron de Bruin http://www.rondebruin.nl "Joe" wrote in message ... Good day, I am looking for a way to add cells together from multiple worksheets within a single spreadsheet. The catch is: I want to be able to create the formula to allow me to insert additional worksheets and still come up with the correct total. Is there a way to reference a cell in a non-existent worksheet? Or is there another way to accomplish my goal? TIA - Joe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding an accumulator for multiple cells | Excel Worksheet Functions | |||
Copying information from multiple worksheets into one | Excel Discussion (Misc queries) | |||
changing cells in multiple worksheets | Excel Worksheet Functions | |||
adding duplicate text to multiple cells | Excel Discussion (Misc queries) | |||
Extracting data from multiple worksheets into a list | Excel Worksheet Functions |