Gradebook woes

  • Thread starter Thread starter G. Doughty
  • Start date Start date
G

G. Doughty

As Eeyore says, "here we go"

I am implementing a gradebook with excel. How can I three assignments
weighted differently and still give me an average in one cell? I also would
like to have columns open to add assignments and to have those assignments
automatically pick up the formula for the average. My problem now is that I
cannot get an average as I go along. All of the Internet sites have
gradebooks that are complete with all the grades and everything but I would
like to add them as they are assigned. Is there a formula that would state
"If J5 is empty, do not include in average but if J5= # then include in
average. I am pulling my hair out with this as I also have different
weights for different assignments. I wish I could just get a template but I
have to do this original gradebook as part of a portfolio. Excel is
obviously my weakest MS application and it is killing me. Thanks for any
suggestions if you can make heads or tails out of my explanation

73
Greg
ki4bbl AT cox DOTNET
 
Greg,

Does this help

=SUMPRODUCT(A1:C1,{7,5,3})/COUNT(A1:C1)

where A1:c1 are the grades, 7,5,3, are the weights
 
Back
Top