Hi michaelas,

Try this ARRAY formula (confirm with Ctrl+Shift+Enter, not just Enter!!!):

=AVERAGE(IF((E2:E100="rec")*(F2:F100<""),F2:F100) )

Regards,
KL


"michaelas" wrote
in message ...

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 and average them in a single cell.
Can anyone help? Thanks

Michaelas


--
michaelas
------------------------------------------------------------------------
michaelas's Profile:
http://www.excelforum.com/member.php...o&userid=26573
View this thread: http://www.excelforum.com/showthread...hreadid=466654