ExcelBanter - How do I add numbers from separate worksheets

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

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

- - How do I add numbers from separate worksheets (https://www.excelbanter.com/excel-discussion-misc-queries/199275-how-do-i-add-numbers-separate-worksheets.html)

Shannon

How do I add numbers from separate worksheets

How can I add numbers from separate worksheets and total them on another sheet?

AKphidelt

How do I add numbers from separate worksheets

well the easiest way is just to do it like you do any other formulas.

Type in the = sign... then click on the cell from the first worksheet and
then the + sign, then click on the cell from the other spreadsheet

"shannon" wrote:

How can I add numbers from separate worksheets and total them on another sheet?

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