ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Totals from sheet to sheet (https://www.excelbanter.com/excel-discussion-misc-queries/226922-totals-sheet-sheet.html)

Skydiver

Totals from sheet to sheet
 
I'd like to total some figures in sheet 3 from sheets 1 & 2. Help!

Per Jessen

Totals from sheet to sheet
 
Select cell A1 in Sheet3, and enter an equal sign, now use the mouse to
select Sheet1 - cell A1. Enter a plus sign and select cell A1 in sheet2.
Press enter

The formula in sheet3 should look like:

=Sheet1!A1+Sheet2!A1

Hopes this helps

Per

"Skydiver" skrev i meddelelsen
...
I'd like to total some figures in sheet 3 from sheets 1 & 2. Help!




All times are GMT +1. The time now is 01:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com