maybe...

=AVERAGE(IF(AND(MoTotals!$F$17:$F$280,B21<date(2 005,4,1)),
MoTotals!$F$17:$F$28))

(still all one cell and still array entered)

jh3016 wrote:

This only returns 0.00%, which is not right. Does this being a date make a
difference? Is there a DATE function that needs to be used?

"Sloth" wrote:

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




--

Dave Peterson