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