Thread: Average
View Single Post
  #1   Report Post  
jh3016
 
Posts: n/a
Default Average

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.