I did not have anything, but I wanted the average to appear there. My
question is:- Is there a formula where the average of the entries in a
column will appear on a line below the last entry in that column, because
the formula you gave me only works if the answer is in the next column,
which is of no use to me, because the next column is used for other entries.
"George Gee" wrote in message
...
Zygy

What do you mean by "but I highlighted the total in G line 36"?
Do you mean that you put the formula there?
What formula have you got in G36?

George Gee


"Zygy" wrote in message
...
Thank you George for solving this problem. However, I always did put
colons in the formula, but I highlighted the total in G line 36 as all
the other totals of Cols. A-F!

Is there a formula that would put the average of the entries in Col.G one
line below the last entry in line with the other totals?

"George Gee" wrote in message
...
Zygy

Use colons, not semi-colons!
Do not place the formula in any cell referenced within the formula!
Try putting =SUM(G31:G99)/COUNTA(G31:G99) in H34
Does this help?

George Gee


"Zygy" wrote in message
...
Thank you all for the contributions. Unfortunately I still cannot get
the
right answer.When I use the semicolon instead of the minus I get a
notice
stating that I made a mistake and will I accept the correction to the
Formula made by Excel, which is exactly the same as the one I typed in.
When I click OK I get another notice stating that Excel cannot carry
out
the calculation, because I created a "Circular Reference"! My OS is
Win.XPPro (SP2) and Office Pro 2003.

Any further suggestions will be gratefully received.
"RagDyeR" wrote in message
...
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