Re: Averages
- From: "Zygy" <zygy@xxxxxxxxxxxxxx>
- Date: Sun, 18 Jun 2006 17:35:10 +0100
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" <georgegee@xxxxxxxxxx> wrote in message
news:uM%23664ukGHA.1640@xxxxxxxxxxxxxxxxxxxxxxx
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" <zygy@xxxxxxxxxxxxxx> wrote in message
news:OvkEBstkGHA.4508@xxxxxxxxxxxxxxxxxxxxxxx
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" <georgegee@xxxxxxxxxx> wrote in message
news:OcIdnBrkGHA.4660@xxxxxxxxxxxxxxxxxxxxxxx
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" <zygy@xxxxxxxxxxxxxx> wrote in message
news:OC%23bgjqkGHA.408@xxxxxxxxxxxxxxxxxxxxxxx
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" <ragdyer@xxxxxxxxxxxxx> wrote in message
news:ut8cL6jkGHA.4212@xxxxxxxxxxxxxxxxxxxxxxx
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" <zygy@xxxxxxxxxxxxxx> wrote in message
news:unFER%23hkGHA.3572@xxxxxxxxxxxxxxxxxxxxxxx
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" <tony.h.29jevb_1150532402.604@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:tony.h.29jevb_1150532402.604@xxxxxxxxxxxxxxxxxxxxxxxx
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?action=getinfo&userid=21074
View this thread:
http://www.excelforum.com/showthread.php?threadid=552892
.
- Follow-Ups:
- Re: Averages
- From: CLR
- Re: Averages
- From: George Gee
- Re: Averages
- References:
- Averages
- From: Zygy
- Re: Averages
- From: tony h
- Re: Averages
- From: Zygy
- Re: Averages
- From: RagDyeR
- Re: Averages
- From: Zygy
- Re: Averages
- From: George Gee
- Re: Averages
- From: Zygy
- Re: Averages
- From: George Gee
- Averages
- Prev by Date: Re: Averages
- Next by Date: Re: Averages
- Previous by thread: Re: Averages
- Next by thread: Re: Averages
- Index(es):
Relevant Pages
|
Loading
