Re: Averages

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I did that before you suggested it but if you look up my first posting you
will see that your suggestion will not work AUTOMATICALLY if I add further
entries on lines 36, 37, 38 ect, ect.. The original formula suggested was
=SUM (G31:G99)/COUNT (G31:G99), which would work if I added further entries
in line 36, 37, ect. but where am I supposed to get the resulting average
then? I have a feeling that there is no solution to my problem. Do all the
contributors agree?
"George Gee" <georgegee@xxxxxxxxxx> wrote in message
news:OZ4RwbvkGHA.836@xxxxxxxxxxxxxxxxxxxxxxx
Zygy

Copy this formula, and paste it in cell G36
=SUM(G3:G35)/COUNTA(G3:G35)
Is this what you want?

George Gee

"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
    ... 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: Averages
    ... not cater for Zygy's first post of being able to ... "add entries above line 35". ... the other totals of Cols. ... Use colons, not semi-colons! ...
    (microsoft.public.excel.newusers)
  • Re: Removing columns and rows from an imported worksheet
    ... with the totals as here. ... These are the total entries for each of the 4 CO's. ... Aging TotDays CO Code ... not fitting the criteria being removed as in "Gone". ...
    (microsoft.public.excel.programming)