Replace your minus signs,

=SUM(G31-G99)/COUNTA(G31-G99)

with colons:

=SUM(G31:G99)/COUNTA(G31:G99)
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Zygy" wrote in message
...
Many thanks for the reply. I am affraid that this formula did not produce
the result for me. I have these entries in line 31-34 Col. G:-

40.66
35.97
38.86
38.88
the average should be 38.59, but with the formula:- =Sum (G31-G99)/COUNTA
(G31-G99) I am getting 40.66 - the first entry. Where did I go wrong?
"tony h" wrote in
message ...

try

=SUM(A31:A99)/COUNTA(A31:A99)

This formula is using data in column A and allows you to fill in values
between rows 31 and 99 without needing to change theformula

hope this helps


--
tony h
------------------------------------------------------------------------
tony h's Profile:
http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=552892