Thread: Averages

Many thanks to all who contributed to my problem. I will follow tony h's
advice and create my own solution, now that I have the averages formula.
Thank you all again and please consider this matter closed.
"George Gee" <georgegee@nomaps.com> wrote in message
news:u$eknlvkGHA.4224@TK2MSFTNGP05.phx.gbl...
> 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@tampabay.rr.com> wrote in message
> news:eJVdYcvkGHA.1260@TK2MSFTNGP05.phx.gbl...
>> Maybe this modification of tony's suggestion, in G36.........
>>
>> =SUM(G31:G35)/COUNTA(G31:G35)
>>
>> Vaya con Dios,
>> Chuck, CABGx3
>>
>>
>>
>> "Zygy" <zygy@bt.connect.com> wrote in message
>> news:emiwuUvkGHA.3484@TK2MSFTNGP03.phx.gbl...
>>> 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@nomaps.com> wrote in message
>>> news:uM%23664ukGHA.1640@TK2MSFTNGP02.phx.gbl...
>>> > 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@bt.connect.com> wrote in message
>>> > news:OvkEBstkGHA.4508@TK2MSFTNGP05.phx.gbl...
>>> >> 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@nomaps.com> wrote in message
>>> >> news:OcIdnBrkGHA.4660@TK2MSFTNGP03.phx.gbl...
>>> >>> 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@bt.connect.com> wrote in message
>>> >>> news:OC%23bgjqkGHA.408@TK2MSFTNGP03.phx.gbl...
>>> >>>> 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@cutoutmsn.com> wrote in message
>>> >>>> news:ut8cL6jkGHA.4212@TK2MSFTNGP03.phx.gbl...
>>> >>>>> 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@bt.connect.com> wrote in message
>>> >>>>> news:unFER%23hkGHA.3572@TK2MSFTNGP04.phx.gbl...
>>> >>>>> 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@excelforum-nospam.com>
>>> >>>>> wrote
>> in
>>> >>>>> message news:tony.h.29jevb_1150532402.604@excelforum-nospam.com...
>>> >>>>>>
>>> >>>>>> 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
>>> >>>>>>
>>> >>>>>
>>> >>>>>
>>> >>>>>
>>> >>>>
>>> >>>>
>>> >>>
>>> >>>
>>> >>>
>>> >>
>>> >>
>>> >
>>> >
>>>
>>>
>>
>>
>
>

You're welcome Zygy, and please don't hesitate to post back if you run into
more problems..........

Vaya con Dios,
Chuck, CABGx3


"Zygy" <zygy@bt.connect.com> wrote in message
news:#pQ52Z5kGHA.4660@TK2MSFTNGP05.phx.gbl...
> Many thanks to all who contributed to my problem. I will follow tony h's
> advice and create my own solution, now that I have the averages formula.
> Thank you all again and please consider this matter closed.
> "George Gee" <georgegee@nomaps.com> wrote in message
> news:u$eknlvkGHA.4224@TK2MSFTNGP05.phx.gbl...
> > 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@tampabay.rr.com> wrote in message
> > news:eJVdYcvkGHA.1260@TK2MSFTNGP05.phx.gbl...
> >> Maybe this modification of tony's suggestion, in G36.........
> >>
> >> =SUM(G31:G35)/COUNTA(G31:G35)
> >>
> >> Vaya con Dios,
> >> Chuck, CABGx3
> >>
> >>
> >>
> >> "Zygy" <zygy@bt.connect.com> wrote in message
> >> news:emiwuUvkGHA.3484@TK2MSFTNGP03.phx.gbl...
> >>> 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@nomaps.com> wrote in message
> >>> news:uM%23664ukGHA.1640@TK2MSFTNGP02.phx.gbl...
> >>> > 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@bt.connect.com> wrote in message
> >>> > news:OvkEBstkGHA.4508@TK2MSFTNGP05.phx.gbl...
> >>> >> 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@nomaps.com> wrote in message
> >>> >> news:OcIdnBrkGHA.4660@TK2MSFTNGP03.phx.gbl...
> >>> >>> 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@bt.connect.com> wrote in message
> >>> >>> news:OC%23bgjqkGHA.408@TK2MSFTNGP03.phx.gbl...
> >>> >>>> 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@cutoutmsn.com> wrote in message
> >>> >>>> news:ut8cL6jkGHA.4212@TK2MSFTNGP03.phx.gbl...
> >>> >>>>> 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@bt.connect.com> wrote in message
> >>> >>>>> news:unFER%23hkGHA.3572@TK2MSFTNGP04.phx.gbl...
> >>> >>>>> 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@excelforum-nospam.com>
> >>> >>>>> wrote
> >> in
> >>> >>>>> message
news:tony.h.29jevb_1150532402.604@excelforum-nospam.com...
> >>> >>>>>>
> >>> >>>>>> 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
> >>> >>>>>>
> >>> >>>>>
> >>> >>>>>
> >>> >>>>>
> >>> >>>>
> >>> >>>>
> >>> >>>
> >>> >>>
> >>> >>>
> >>> >>
> >>> >>
> >>> >
> >>> >
> >>>
> >>>
> >>
> >>
> >
> >
>
>