HELP! In Excel

Discussion in 'Computers & Website Forum' started by thjplgvp, Oct 27, 2006.

  1. thjplgvp

    thjplgvp
    Expand Collapse
    Member

    Joined:
    Mar 21, 2006
    Messages:
    978
    Likes Received:
    23
    I feel like an idiot this morning / afternoon. I want to add 3 numbers take their total and divide it by a set number for an average.

    Hypothetically let us say the numbers are 500, 1234, 3600 and I want to divide these numbers by 82

    Cell 1 =500 Cell 2 =1234 and Cell 3 = 3600 this total divided by 82 total to show up Cell 6

    Culd someone submit the formula before I try to beat the answer out of my computer? :BangHead:

    Thjplgvp
     
  2. rsr

    rsr
    Expand Collapse
    <b> 7,000 posts club</b>
    Administrator

    Joined:
    Dec 11, 2001
    Messages:
    10,079
    Likes Received:
    103
    Cell 6=(Cell1+Cell2+Cell4)/82

    Or, depending on how the numbers are laid out: A4= (A1+A2+A3)/82

    (There are simpler ways to do this to allow insertion of additional numbers -- using the SUM function -- but this general formula should work.)
     
  3. thjplgvp

    thjplgvp
    Expand Collapse
    Member

    Joined:
    Mar 21, 2006
    Messages:
    978
    Likes Received:
    23
    RSR

    Thank you so much. I was trying to put sum, avg, etc in front of the formula and that is where I was goofing.

    Thjplgvp
     
  4. James_Newman

    James_Newman
    Expand Collapse
    Banned

    Joined:
    Aug 27, 2004
    Messages:
    5,013
    Likes Received:
    0
    I always love it when someone uses excel to put together a spread sheet and they don't use formulas, they just use a calculator and plug the numbers in manually.:tongue3:
     
  5. rsr

    rsr
    Expand Collapse
    <b> 7,000 posts club</b>
    Administrator

    Joined:
    Dec 11, 2001
    Messages:
    10,079
    Likes Received:
    103
    The SUM command does indeed work beautifully, and it allows you to add lots of data without having to reset all the cells manually.

    The example for the case listed above is: =SUM(A1:A3)/82

    If you insert additional numbers into the column, you can just adjust the parameters for the series - a1:a3, for example, to a1:a60 - without having to manually enter all the additional cells into the formula.
     
    #5 rsr, Oct 27, 2006
    Last edited by a moderator: Oct 27, 2006
  6. rsr

    rsr
    Expand Collapse
    <b> 7,000 posts club</b>
    Administrator

    Joined:
    Dec 11, 2001
    Messages:
    10,079
    Likes Received:
    103
    At least the numbers look pretty ...
     

Share This Page

Loading...