ExcelBanter - calculate totals of 5 sheets on to 6th sheet.

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - calculate totals of 5 sheets on to 6th sheet. (https://www.excelbanter.com/excel-worksheet-functions/19192-calculate-totals-5-sheets-6th-sheet.html)

salvo

calculate totals of 5 sheets on to 6th sheet.

NEED FORMULA PLEASE
I have a file with 6 work sheets. I would like to take the totals of the
first five work sheets and have a gtand total on the 6th work sheet
example
sheet 1 34N is $55:00
sheet 2 34N is $75.00
and so on
sheet 6 would have a geand total of the first two sheets $130.00

Roger Govier

Hi

Try =SUM(Sheet1:Sheet5!N34)

--
Regards
Roger Govier
"salvo" wrote in message
...
NEED FORMULA PLEASE
I have a file with 6 work sheets. I would like to take the totals of the
first five work sheets and have a gtand total on the 6th work sheet
example
sheet 1 34N is $55:00
sheet 2 34N is $75.00
and so on
sheet 6 would have a geand total of the first two sheets $130.00

All times are GMT +1. The time now is 12:56 PM.