Do I need to use SUMIF?

[tenglish01]

In the attached spreadsheet, I need to add the mileage for each day. L3 contains the total mileage for the day.

In L7:L10 it tells me whether the trip is One Way (OW) or Round Trip (RT). The mileage in column M is ALWAYS for one way (my cost is calculated if it is one way or round trip automatically). I need a formula in L3 that will double the mileage if the TRIP in column L says "RT."

Can anyone help with this? Thanks!! travel book template.xlsx

[Jonmo1]

Try

=SUMPRODUCT(M7:M100,(RIGHT(L7:L100,3)=" RT")+1)

[Pete_UK]

You can use this array* formula:

=SUM(IF(RIGHT(L7:L10,2)="RT",2,1)*(M7:M10))

*An array formula needs to be committed using the keystrokes <CTRL><SHIFT><ENTER> (CSE), rather than the usual <Enter>.

Hope this helps.

Pete

[tenglish01]

Perfect! Thank you!

[Jonmo1]

You're welcome.