Condition setup

  • Thread starter Thread starter Teched
  • Start date Start date
T

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
 
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.
 
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.
 
Back
Top