Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Formula's
I have created a mileage log in Excel 2003. I have also added a dropdown box
where the user can select whether the mileage is used on a "personal" or "business" basis. i.e. Odometer Reading Select Purpose Start Finish Mileage Personal 2500 3000 500 Business 3000 3250 250 Personal 3250 3255 5 Business 3255 3355 100 Total of Personal Mileage Used: 505 km Total of Business Mileage Used: 350 km I have two separate cells that say: " Total of Personal Mileage Used:" and "Total of Business Mileage Used:" What I am looking for is to be able to total all of these based on what has been selected "personal" or "business." I am unsure how to do this and do not know the formulas well enough to implement them. If someone can offer suggestions, examples etc. it would be greatly appreciated. Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Formula's
On Jul 2, 3:56 pm, Tannis1005
wrote: I have created a mileage log in Excel 2003. I have also added a dropdown box where the user can select whether the mileage is used on a "personal" or "business" basis. i.e. Odometer Reading Select Purpose Start Finish Mileage Personal 2500 3000 500 Business 3000 3250 250 Personal 3250 3255 5 Business 3255 3355 100 Total of Personal Mileage Used: 505 km Total of Business Mileage Used: 350 km I have two separate cells that say: " Total of Personal Mileage Used:" and "Total of Business Mileage Used:" What I am looking for is to be able to total all of these based on what has been selected "personal" or "business." I am unsure how to do this and do not know the formulas well enough to implement them. If someone can offer suggestions, examples etc. it would be greatly appreciated. Thanks! Look under SUMIF in the help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Formula's | Excel Discussion (Misc queries) | |||
Excel Formula's | Excel Worksheet Functions | |||
excel formula's | Excel Worksheet Functions | |||
Excel Formula's | Excel Worksheet Functions | |||
Excel Formula's | Excel Worksheet Functions |