Gradebook woes

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

--
HTH

Bob Phillips

"G. Doughty" <[email protected]> wrote in message
news:k6pXd.56003$7z6.21606@lakeread04...
> 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
>
>

Maybe...........

=SUM(J1:J20)/COUNT(J1:J20)

Vaya con Dios,
Chuck, CABGx3



"G. Doughty" <[email protected]> wrote in message
news:k6pXd.56003$7z6.21606@lakeread04...
> 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
>
>