ExcelBanter - Cell Reference

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Cell Reference (https://www.excelbanter.com/excel-discussion-misc-queries/225207-cell-reference.html)

onebodaciousbabe03

Cell Reference

How do I reference the total of a formula on sheet 1 to sheet 2? I hope that
makes sense. Thank you in advance.

Sheeloo[_4_]

Cell Reference

If total is in cell H1 of Sheet1 then use this in the cell in Sheet2 you want
the total
=Sheet1!H1

If you want to sum the cells on Sheet1 in a cell in Sheet2 then use
=SUM(Sheet1!A1:A10)

"onebodaciousbabe03" wrote:

How do I reference the total of a formula on sheet 1 to sheet 2? I hope that
makes sense. Thank you in advance.

All times are GMT +1. The time now is 06:25 AM.