Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Oct 2004
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formulas (Excel 2002)

    I need to know how to correctly input a formula for computing the final average for my students.
    I understand the general idea of using parentheses and adding up each to get the total but what I am stuck on is how to get it to actually do the calculation and how to get the program to do the calculation for each row, treating each row as a separate set of calulations after I have highlighted the entire row in whcih the average will appear. I'll attach my excel sheet I am using. If you look at the sheet titled HNRS 100 perhaps you can tell me what to do specifically here and I can transfer the information to the other sheets. In the case of HNRS 100, the percentage of the final grade, starting from the left and moving to the right, is as follows: 30%, 10%,10%,10%,15%, 15%, and 10%. The "Total %" column is where I want the average to appear.

    Can you help?

    See Attachment

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formulas (Excel 2002)

    Put the formula below in cell J3 and then copy it down as far as needed:

    <pre>=C3*0.3+D3*0.1+E3*0.1+F3*0.1+G3*0.15+H3*0.15+ I3*0.1
    </pre>


    Does that do what you want?
    Legare Coleman

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Formulas (Excel 2002)

    In addition to Legare's formula:
    If you place your percentages in row 1(C1:I1 the values 30%, 10%,10%,10%,15%, 15%, and 10%, repectively). You can then put the calculation in J3:
    <pre>=SUMPRODUCT($C$1:$I$1,C3:I3)</pre>


    This can be copied down the column.

    You can change th values in row 1 and the formulas will be updated.

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •