ExcelBanter - sum a specific cell in more than one sheet

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - sum a specific cell in more than one sheet (https://www.excelbanter.com/excel-programming/368838-sum-specific-cell-more-than-one-sheet.html)

plainclothman

sum a specific cell in more than one sheet

I want to sum cell A1 in sheet1,...,sheet100 .I type (sheet1:sheet100)!$a$1
but it doesn't work

Michael

sum a specific cell in more than one sheet

Include the Cell reference inside the parenthesis like so:

=SUM(Sheet2:Sheet3!A1)

"plainclothman" wrote:

I want to sum cell A1 in sheet1,...,sheet100 .I type (sheet1:sheet100)!$a$1
but it doesn't work

All times are GMT +1. The time now is 12:35 AM.