ExcelBanter - adding cells

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

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

- - adding cells (https://www.excelbanter.com/excel-discussion-misc-queries/184645-adding-cells.html)

msiz

adding cells

hi

I have a spreadsheet with numerous shhets and I want to add the same cell
(ie add cell A3 in sheets 1-sheet 30) in each sheet together. Is there an
easy way to do this?

thanks
msiz :)

Andrea Jones

adding cells

Use =SUM(Sheet1:Sheet30!A3)

Andrea Jones

"msiz" wrote:

hi

I have a spreadsheet with numerous shhets and I want to add the same cell
(ie add cell A3 in sheets 1-sheet 30) in each sheet together. Is there an
easy way to do this?

thanks
msiz :)

All times are GMT +1. The time now is 11:45 PM.