=SUMPRODUCT(--ISNUMBER(H21:H51)),H21:H51)/COUNTA(H21:H51)

-----CTRL SHIFT ENTER

THis forumla works for averaging without adding numbers that are < but
how would I get this formula to work and put a 0 in the average space if
all the numbers are <. THe max and min must show the number with the <.
The MIN can not show 0 for the lowest number, it has to be one of the
results listed.


Example:

Sunday <2
Monday
Tuesday <2
Wednesday
Thurdaday <2
Friday <2
Saturday <

Average:
MAX
MIN


--
hamricka
------------------------------------------------------------------------
hamricka's Profile: http://www.thecodecage.com/forumz/member.php?userid=676
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=127104