I am setting up a worksheet to manage gradebooks for my school. Sheet
contains the student scores. Each column of scores is identified by on
of six different activities (homework, tests, etc). I am using th
activity identifiers to allow weighting averages. Sheet 2 is a summar
sheet which shows the totals for each activity and averages the weighte
scores.

I am able to calculate the averages for each student using SumIF an
CountIF functions. However, I am stumped trying to pass the result t
Sheet 2 in order to finish the calculations. I want to pass th
calculated result only, in order to allow the option of calculatin
based on weighted or straight averages on Sheet 2.

I'm guessing there must be a way to pass the result using variables
but I just haven't been able to figger it out! HELP! -- School start
next week and my teachers are counting on me.

Daniel Co

--
Message posted from http://www.ExcelForum.com