Re: Averages

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
    ... Thank you George for solving this problem. ... I always did put colons ... line below the last entry in line with the other totals? ... tony h's Profile: ...
    (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: Cannot get code to work for API Save Dialog Box
    ... Your totals are not saved with it. ... ' Declare necessary API routines: ... switch to the Excel sheet to see what happened. ... Dim Hwnd As Long ...
    (microsoft.public.access.forms)
  • RE: Cannot get code to work for API Save Dialog Box
    ... I thought I put the formula in the spreadsheet with the .cell, ... Your totals are not saved with it. ... difference at all to the output in excel. ... ' Declare necessary API routines: ...
    (microsoft.public.access.forms)
  • RE: Cannot get code to work for API Save Dialog Box
    ... Then you could include it in your query and export it to Excel ... to use the default value property of the new text box to do the calculation. ... I checked the cells in the spreadsheet created and the cells are blank. ... cells where you expect the formula to calculate the totals. ...
    (microsoft.public.access.forms)