1. ## 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. ## 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?

3. ## Re: Formulas (Excel 2002)

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
•