Hi,
I'm using a worksheet as an auto mileage log as follows:
Col. A = date
Col. B= Start mileage for day
Col. C = End mileage for day
Col D = Total for day
Col E = Description/Destination

In column E, if I did not have work related mileage on a given day, I
list the description as "No Work."

My question is this:
How do I construct a formula so I can find the total mileage of all my
"No Work" trips, and have that mileage automatically totaled in one
cell? (preferably on-going, as I add mileage from day to day)

Appreciate any help.
michaelas


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