Mileage Form...Need help with auto populating total miles

Hi! Hoping to get some help. I have a mileage form I'm currently working on. I didn't build it but I'm trying to help someone update it.
They've created a drop down list too on the first worksheet. When two sites are selected the total miles auto populates and so does a total.
We recently added a few new sites. I was able to figure out the data validation part of it to add the new sites to the drop down.
However, their mileage is not calculating. Any suggestions would be welcomed and greatly appreciated. Thank you!!

Try this formula:

Please Login or Register  to view this content.

I placed it into N8, and it seemed to work.

I hope this helps, please let me know!

Regards,

David

If this has been helpful
- Please click on the *Add Reputation button at the bottom left.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

Thank you so much!! I saw that there were hidden columns but when I tried to unhide a few it didn't work for me.
I appreciate your speedy reply!! In regards to the use of dynamic named ranges, I'd love to learn if you could show me what you mean.
Thanks again!!! -CG

BSB has a good point regarding the named ranges.

Let me point you to a website which covers the topic very well. I find Debra Dalgleish very helpful.

http://www.contextures.com/xlNames01.html

Regards,

David