I have set up several scales of fees which are totalled up in cells at the bottom of each column. These are then totalled in further separate cells at the bottom of the sheet.
I have two sheets the same and want to add the overall totals from both sheets to create a grand total.
I've tried the =SUM method in conjunction with the sheet names/cell no (in brackets) - when i have finished the sum it either says #VALUES or tries to open a file type??!!??
Sheet names should not be placed in cell brackets. To sum the appropriate data, the nomeclature is as follows:
=SUM(SheetName1!A1,SheetName2!A1,...)
Note the inclusion of the "!" after the sheet name, followed by the cell within that sheet you wish to sum. This can also work with ranges. Brackets are usually reserved for table range values. If you are still having issues, attaching a small sample workbook could generate more assistance.
Hope this helps!
Spread the love, add to the Rep
"None of us are as smart as all of us."
Enter =SUM( now click on the first sheet tab from which you want to retrieve a value and click on the cell that has that value. Enter a comma (,) and click on the next sheet tab that has a value to be retrieved and click on the cell that has the value. Repeat until all values have been selected then enter a ) to finish the formula.
When finished, your formula will look like that provided by mcmahobt or with real sheet names like this: Note the ' around names with more than 1 word.
Formula:
=SUM('Household Budget'!A7,Sheet3!E23,'Bank Balance'!H42)
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
BeamDesign 
Register To Reply
Bookmarks