| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula's / Programming
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.misc
|
|||
|
|||
|
Excel Formula's / Programming
hi
=sumif(A2:A500,"personal",D2:D500") =sumif(A2:A500."Business",D2:D500") Adjust to suit. Regards FSt1 "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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formula's / Programming
Thank you so much!!!
"FSt1" wrote: hi =sumif(A2:A500,"personal",D2:D500") =sumif(A2:A500."Business",D2:D500") Adjust to suit. Regards FSt1 "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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formula's / Programming
Ooops, a little slip
=sumif(A2:A500,"personal",D2:D500) =sumif(A2:A500,"Business",D2:D500) best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "FSt1" wrote in message ... hi =sumif(A2:A500,"personal",D2:D500") =sumif(A2:A500."Business",D2:D500") Adjust to suit. Regards FSt1 "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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formula's / Programming
yep.
thanks for catching that. regards FSt1 "Bernard Liengme" wrote: Ooops, a little slip =sumif(A2:A500,"personal",D2:D500) =sumif(A2:A500,"Business",D2:D500) best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "FSt1" wrote in message ... hi =sumif(A2:A500,"personal",D2:D500") =sumif(A2:A500."Business",D2:D500") Adjust to suit. Regards FSt1 "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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Or Excel Programming | Excel Worksheet Functions | |||
| ExCel programming | Charts and Charting in Excel | |||
| ADO programming in Excel-VBA | Excel Discussion (Misc queries) | |||
| Excel Programming | Excel Worksheet Functions | |||
| Excel/VBA programming | Excel Discussion (Misc queries) | |||
Linear Mode
