Re: Averages

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
    ... Use colons, not semi-colons! ... 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 ... tony h's Profile: ...
    (microsoft.public.excel.newusers)
  • Re: Averages
    ... I am affraid that this formula did not produce ... I have these entries in line 31-34 Col. G:- ... tony h's Profile: ...
    (microsoft.public.excel.newusers)
  • Re: Lookup , match, not sure !?
    ... HTH, ... Please keep all correspondence within the Group, ... As it is now Tony in A matches with Phil ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Orlow cardinality question
    ... >> notation. ... > And what if you have N colons? ... Tony ... Prev by Date: ...
    (sci.math)
Loading