Average Function Help Needed

<< Hi,

I'm trying to calculate average miles in my mileage log.
Col. F = total miles for each day
Col E = destination eg. store, supplyhouse, rec, auto, etc

I want to total all the "rec" miles >>

=sumif(E1:E100,"rec",F1:F100)


<< and average them in a single cell. >>


=sumif(E1:E100,"rec",F1:F100)/countif(E1:E100,"rec")


Regards.

To determine the average of your non "rec" entries, simply change "rec" to "<>rec" so your formula will look like this:


=sumif(E1:E100,"<>rec",F1:F100)/countif(E1:E100,"<>rec")


Regards.

You are welcome... I am just glad that I can help. Thanks for the feedback.

Regards.