Try this:

=SUM(A1:A31)/COUNTA(A1:A31)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Clarification on Function Question"
soft.com wrote in message
...
Good try but the answer still comes up as 19.2 and I need it to be 15.2.
Here
is the collumn as it appears on the form maybe that will help. These are
test
results for the month of June. The formula needs to be able to adjust for
the
number of days of the month but count the < numbers as 0 in the average. I
have tried everthing I can think of please give it another try.

50060
RESIDUAL CHLORINE
mg/L
UG/L

16.00








21.00




39.00






< 10.00






< 10.00

19.20
39.00 39.00
10.00 10.00
G


"NBVC" wrote:


hamricka;453508 Wrote:
I have a spread sheet in which laboratory results are entered. So of
the
results are less than numbers I do not want to include the less than
results in the average how do I write a formula for this. I am using
excel2003.?



Example: 21
16
39
<10
<10

If you are trying to avoid the 2 "<10" in your average, then try:

=AVERAGE(IF(ISNUMBER(A1:A5),A1:A5))

where A1:A5 is the whole range.

Note: The fomrula must be confirmed with CTRL+SHIFT+ENTER not just
ENTER. You will see { } brackets appear around it


--
NBVC

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=125542