Calculating the right formula
 

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

Hi!

One way:

=SUMIF(E:E,"No Work",D:D)

This formula uses entire columns as ranges, so, as you add data to the table
the formula will automatically calculate any new data that meets the
criteria. Just don't put the formula in either column D or E.

Biff

"michaelas" wrote
in message ...

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

Hi michaelas,

try SumIf

e.g.

=SumIf(E1:E100,"No Work",D1:D100)

Obviously, amend the ranges (E1 to E100 and D1 to D100) to suit your
circumstances.

Art


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

Thanks Art & Biff. It worked great!
Appreciate the help & quick replies.

michaelas


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