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

Thread Starter
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
 

Couriant

James
Trusted Advisor
Spam Fighter
Joined
Mar 26, 2002
Messages
36,265
=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.
 
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.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top