1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

SUM in Excell problem

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

Thread Status:
Not open for further replies.
Advertisement
  1. Shuno

    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
     
  2. Couriant

    Couriant Trusted Advisor

    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.
     
  3. Shuno

    Shuno Thread Starter

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

    Couriant Trusted Advisor

    Joined:
    Mar 26, 2002
    Messages:
    32,491
    First Name:
    James
    (y) anytime
     
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 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/325216

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice