[michaelas]

Hi
I'm using Excel (2003) to record auto mileage.
I have it set up well enough except for one thing.
Please refer to the screenshot.

 Mileage Log example.jpg (66.61K)
Number of downloads: 5


Columns A – D are self-explanatory, start and end mileage, etc
Column E is the total miles for the day
Column F describes gen'l info for the day.
Cell G 2 is total business miles
Cell H 2 (highlighted in screenshot) is total “rec” or recreation miles

Notice the formula for H 2 –> =SUMIF(F:F,”rec”,E:E)
This means that if I type rec in column F, as in F 3, the miles are considered recreation miles, and therefore are recorded in cell H 3. Conversely, if rec is not typed in, (as in cell F 4), then the resulting mileage goes to cell G 3. So far so good.

The problem is, if I want to type in rec and additional info, eg “rec, went to store”, then the mileage shifts to column G instead of H. ie, The rec miles become business miles.

My question is, how do I amend the formula so it will record “rec” miles, but I can also write other info in the same cell in Column F.

Hope this is clear. Thanks in advance for your help.