Clarification on Function Question;453545 Wrote:
I need to correct my statement the collumn contains 21, 16, 39, <10,
<10.
When I average this collumun I need to count place holders for the <
values,
so it would be like adding 21, 16, an 39 then dividing by five, but the
total
number of values in the collum could range from 0 to 31 on any day with
some
of them being < than figures.

"hamricka" 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


--
hamricka

------------------------------------------------------------------------
hamricka's Profile: 'The Code Cage Forums - View Profile: hamricka'
(http://www.thecodecage.com/forumz/members/hamricka.html)
View this thread: 'Forumla Question for Excel2003 - The Code Cage
Forums' (http://www.thecodecage.com/forumz/sh...d.php?t=125542)



Then perhaps:

=SUMPRODUCT(--(ISNUMBER(A1:A5)),A1:A5)/COUNTA(A1:A5)

regularly entered.


--
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