Condition setup

[Teched]

Good day,

Using the attached Excel spreadsheet, could some tell me how to compute
"Personal Mileage" and "Business Mileage" based on the user selecting either
Personal or Business.

Thanks ahead of time,

Ron

 

[Jim]

Thanks so much for NOT attaching your file. <g>

=SUMIF(A2:A1000,"Business",B2:B1000)

where Column A has entries Business or Personal and Column B has the miles.

 

[Teched]

Jim,

Thanks for the information. I will modify the worksheet with your forumla.
It makes sense now.

Thanks again and have a Great Holiday Season.