# SUM in Excell problem

Discussion in 'Business Applications' started by Shuno, Jan 31, 2005.

Not open for further replies.

Joined:
Jan 31, 2005
Messages:
2
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

Joined:
Mar 26, 2002
Messages:
32,491
First Name:
James
=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.

Joined:
Jan 31, 2005
Messages:
2
Problem solved. Thanks for the quick response!

Joined:
Mar 26, 2002
Messages:
32,491
First Name:
James
anytime

As Seen On