[addtoany]

Referencing the Same Cell on Multiple Sheets

Most people know that you can refer to a cell range by writing, for example, A1:A10, which in a sum formula looks like SUM(A1:A10). But few know that, in the same way that you refer to cells that are in sequence, you can also refer to sheets that are in sequence, by writing Sheet1:Sheet3!A1, or even SUM(Sheet1:Sheet3!A1:A10). This is useful when you have many sheets with the same structure and want to quickly make a calculation with cell(s) from several of the sheets.

Referencing the same cell on multiple sheets – Example

1 file(s)   0.00 KB

Some of our customers

We have both large and small companies as customers.