ExcelBanter - Adding the same cell in different worksheets. Can that cell be variable?

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Adding the same cell in different worksheets. Can that cell be variable? (https://www.excelbanter.com/excel-worksheet-functions/41000-adding-same-cell-different-worksheets-can-cell-variable.html)

Adding the same cell in different worksheets. Can that cell be variable?

I want to use the same formula =SUM(Sheet1:Sheet2!A1), but i want to be
able to have the column/row as a variable, like
=SUM(OFFSET(C3,1,1,$B$2)).

Basically i don't want to duplicate the same formula n times. And want
to add a variable range.

Can anybody help?

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