Andrew Taylor wrote:
=AVERAGE(IF(E3:E26180,E3:E26))

This needs to be entered as an array formula:
press Ctrl-Alt-Enter instead of Enter after
entering the formula/



Happybattles wrote:
Tried:
=IF(AVERAGE(E3:E29)180,,AVERAGE(E3:E29))
and
=IF(AVERAGE(E3:E29)180,NULL,AVERAGE(E3:E29))
and
=IF(AVERAGE(E3:E29)180,NILL,AVERAGE(E3:E29))

Been a while since I've done any VB... but there must be a way to tell
it that there's no value whatsoever and to ignore it...

That part works now, thank you.
Now I'm trying to get the cell that tells the date difference to:
Load a null value into the cell if the number of days is greater than
360.

But it isn't working. The average is still showing:
38818

The loaded values of 29 a
0
51
23

Here's the formula I'm trying... but I still think its showing a huge
value for number of days when it has nothing to compare it to:
{=AVERAGE(IF(E3:E29180,E3:E29))}

This is essentially a nested IF-THEN statement... but it's loading off
the results of another IF-THEN... This is what is in the cell its
looking at:
=IF(TODAY()-E3<200,IF(TODAY()-E3360,"",TODAY()-E3),"")