Easiest would be to have a dummy column at the end and insert BEFORE that
column.
or look for a number larger than in your data
=COUNT(c3:OFFSET(c3,0,MATCH(99999,3:3)))

--
Don Guillett
SalesAid Software

"David" wrote in message
...
I hope I phrase everything correctly. I have created a teacher grade
workbook. The rows A3 - A33 are students names. The columns C3 - C????
(???
= want to add additional grades (columns) when needed) are numeric test
scores.

B3 is my counter. I cant seem to get my formula in cell B3 to update when
I
add 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 for
example, the counter does not update. Is this the formula I should be
using?
What formula should I be using?

=COUNT(C3:J3)

When I average a cell (all numeric grades) I use the formula below which
does not update either. This formula is always located in the column next
to
the last numeric test score. When I insert a column to add another test
score
I would like this formula to update. Example: J3 should read K3 when I
insert
a column. How can I get the formula to update? Is this the correct formula
I
should be using?

=SUM(C3:J3)/$B$3

Here is the formula I use when I want to convert a numeric value (average
of
all test scores) to 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",I F(K3=69.5,"D","F"))))

Thanks,

--
David