Car mileage expenses

Hi

Newbie here....

I am trying to make what I thought would be a simple spreadsheet: I work for three different organisations and want to be able to record my car mileage along with a category in a drop down list which indicates which organisation I was driving for that day.

I have the drop down list but I can't work out how to make excel add a total to the relevant column for each organisation. I'm sure its simple but i can't do it!

Thanks in advance

Mark

Originally Posted by TMShucks

It would help a lot if you posted a sample workbook. Otherwise you're relying on the imagination of the forum members. Though they're good, they're (mostly) not psychic ;-)

Regards

Mmmm not sure how to do that either...

Date Purpose Start Finish Miles Category CAVA Parish Diocese
100 110 10 CAVA
1 2 1 CAVA
0
0 CAVA
0 Parish
0 Diocese
0 Mileage Rate 0.4
0
0
0
0
0
0
0
0
0
0

Ah i think this is what you mean....

Mark,

I have attached a modified version of your workbook. Is something like that what you're looking for?

~tigeravatar

Originally Posted by tigeravatar

Mark,

I have attached a modified version of your workbook. Is something like that what you're looking for?

~tigeravatar

FAB - Thank you very much, I thought it was simple!
Mark