Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding row to forumla | Excel Discussion (Misc queries) | |||
Formula for Calculating a Floating Date | Excel Worksheet Functions | |||
Need help with a formula for calculating based on a rage of dates | Excel Discussion (Misc queries) | |||
Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |