Tech Support Guy banner
Status
Not open for further replies.
1 - 4 of 4 Posts

·
Registered
Joined
·
2 Posts
Discussion Starter · #1 ·
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
 

·
Super Moderator
Joined
·
43,959 Posts
=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.
 
1 - 4 of 4 Posts
Status
Not open for further replies.
Top