D
David
I have never asked a question here before so I hope I phrase everything
correctly. I have created a teacher grade workbook.
I can’t seem to get my formula in cell B3 to update when I ad a column to
include additional test score. B3 is my counter used when I average the sum
of the test scores. (see below) If I insert a column K the counter does not
update. Why? What formula should I be using?
=COUNT(C3:J3)
When I average a cell I use the following formula which does not update
either when I insert a column to add another test score. J3 should read K3
when I insert a column. What formula should I be using?
=SUM(C3:J3)/$B$3
Here is the formula I use when I want to see a letter grade for the
averages. When I insert a column the reference K3 should read L3 (this is the
column I have my averages of all the tests showing). How do I get the formula
to update? Is there a better formula I should be using?
=IF(K3>=93.5,"A",IF(K3>86.5,"B",IF(K3>78.5,"C",IF(K3>69.5,"D","F"))))
Thanks,
correctly. I have created a teacher grade workbook.
I can’t seem to get my formula in cell B3 to update when I ad a column to
include additional test score. B3 is my counter used when I average the sum
of the test scores. (see below) If I insert a column K the counter does not
update. Why? What formula should I be using?
=COUNT(C3:J3)
When I average a cell I use the following formula which does not update
either when I insert a column to add another test score. J3 should read K3
when I insert a column. What formula should I be using?
=SUM(C3:J3)/$B$3
Here is the formula I use when I want to see a letter grade for the
averages. When I insert a column the reference K3 should read L3 (this is the
column I have my averages of all the tests showing). How do I get the formula
to update? Is there a better formula I should be using?
=IF(K3>=93.5,"A",IF(K3>86.5,"B",IF(K3>78.5,"C",IF(K3>69.5,"D","F"))))
Thanks,