Calculate Yes / No Variables?

Hi Excel Users,

I create a spreadsheet that displays 3 desinations. 2 of the destinations are fixed locations or has a fixed distance. The third desination can vary.

I'm trying to determine the total mileage if I go to Point A, B or C. I have a list of dates & by inserting a Y for Yes or N for No if destination was made.

I'm trying to figure a formula that can calculate the variable by using a bunch of "IF" formulas. I managed to get partially working, but I think my formula is negating one of my possible outcomes & thus, giving me a FALSE or incorrect answer.

I attached the spreadsheet for example.

Thanks for the assistance.