Re: Averages

Chuck

I thought about posting that formula, but it does
not cater for Zygy's first post of being able to
"add entries above line 35" (his wording).
So I suggested the range G3:G35.
Hope we get there soon!

George Gee

"CLR" <croberts@xxxxxxxxxxxxxxx> wrote in message
news:eJVdYcvkGHA.1260@xxxxxxxxxxxxxxxxxxxxxxx
Maybe this modification of tony's suggestion, in G36.........

=SUM(G31:G35)/COUNTA(G31:G35)

Vaya con Dios,
Chuck, CABGx3



"Zygy" <zygy@xxxxxxxxxxxxxx> wrote in message
news:emiwuUvkGHA.3484@xxxxxxxxxxxxxxxxxxxxxxx
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



















.

Relevant Pages

  • Re: Averages
    ... will see that your suggestion will not work AUTOMATICALLY if I add further ... other entries. ... the other totals of Cols. ... Use colons, not semi-colons! ...
    (microsoft.public.excel.newusers)
  • Re: Averages
    ... I will follow tony h's ... "add entries above line 35". ... the other totals of Cols. ... Use colons, not semi-colons! ...
    (microsoft.public.excel.newusers)
  • Re: Averages
    ... column will appear on a line below the last entry in that column, ... which is of no use to me, because the next column is used for other entries. ... the other totals of Cols. ... Use colons, not semi-colons! ...
    (microsoft.public.excel.newusers)
  • Re: Averages
    ... question is:- Is there a formula where the average of the entries in a ... the other totals of Cols. ... Use colons, not semi-colons! ... I am getting 40.66 - the first entry. ...
    (microsoft.public.excel.newusers)
  • Re: Strings to search for in Apache Access log
    ... Michael Heiming wrote: ... >>This is my first post to COLS, though I have been lurking here for ... >>search for in my Apache access log. ... >>entries, ...
    (comp.os.linux.security)