=AVERAGE(IF(AND(MoTotals!$F$17:$F$280,B21<"4/1/2005"),MoTotals!$F$17:$F$28))

This should work as well.

"jh3016" wrote:

Sorry, what I want: if B21 not equal to "4/1/2005", then calculate the rest
of the formula.



"Bob Phillips" wrote:

Do you just want to do the average if and only if a certain cell value is
equal to the value in A21? If so, then

=IF(B21=A21,AVERAGE(IF(MOTotals!$F$17:$F$280,MOTo tals!$F$17:$F$28)),"")

as an array formula

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"jh3016" wrote in message
...
Here's my formula:
=AVERAGE(IF(MoTotals!$F$17:$F$280,MoTotals!$F$17: $F$28))

Now I want to add in this formula
And If cell < A21

Just not sure how to put andif

Thanks in advance.