Add equal cells from different sheets

**ADB** · 03-05-2010, 01:45 AM

Hi,

I'm wondering how I can add up equal cells from different worksheets easily.

So I have data in G9 in 12 different sheets (all months of the year) and I want to add them up in G9 in the 13th sheet. Can this be done easily instead selecting them one by one?

Thanks

ADB

**quekbc** · 03-05-2010, 02:18 AM

Here's what you do.

Arrange the 12th sheets together so they are adjacent to one another, then on the 13th sheet, type in the SUM formula, and select the cell G9 in the first sheet, hold shift, and click on the the 12th sheet (make sure it selects all 12 sheets) then press Enter.

If the sheets are arranged such that,
Sheet1, Sheet2, Sheet3, ... ,Sheet12 then the formula should look something like this...

Code:

=SUM('Sheet1:Sheet12'!G19)

**ADB** · 03-05-2010, 02:47 AM

Originally Posted by quekbc

Here's what you do.

Arrange the 12th sheets together so they are adjacent to one another, then on the 13th sheet, type in the SUM formula, and select the cell G9 in the first sheet, hold shift, and click on the the 12th sheet (make sure it selects all 12 sheets) then press Enter.

If the sheets are arranged such that,
Sheet1, Sheet2, Sheet3, ... ,Sheet12 then the formula should look something like this...

Code: