hamricka;459369 Wrote:
You answered the average question on the August 15 th. but now I need
to take that answer a step further and have the formula for average show
0 if all the numeric values are <.

As far as I can see, the formula for the Average that I gave you:

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

does return 0 if all values have a < in front.


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