# SUM in Excell problem

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

#### Shuno

I'm pretty new to Excell and I constantly have to browse through the help section to figure out how to do use different function. I couldn't find any answar to my problem so I figured this is the place to ask.

Now, I'm trying to sum data from the same columns in different sheets, but I can't figure out the formula.

Let's say I want to sum data from columns B22:B28 in Sheet 1, Sheet 2, Sheet 3 and Sheet 4.

How do I write this formula? I have no problems summing from one sheet, =SUM(Sheet1!B22:B28), but when I try to add more sheets to the formula it all just gets messed up.

Hope any of you provides me with an answer!

Thanks

-J

#### Couriant

James
Moderator
=SUM(E9:E15,Sheet2!E14,Sheet3!E11:E18)

There is a limit of 30 columns. Just make sure that the cell range is corract with all the puncuations and there is a comma inbetween the ranges. There is no spaces either, like my formula shows.

You don't have to put SHEET1 in if the formula is on SHEET1, though it doesn't matter really, the worksheet will know what to do. Just keep within the formula.

#### Shuno

Problem solved. Thanks for the quick response!

#### Couriant

James
Moderator
anytime

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

As Seen On