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??!!??