Formulas and Calculations

dennis.goudy72296

I know this is a simple formula in SS and Excel but I am having trouble writing it.  

In one of my SS's I want to Insert a "Beginning Miles"  and then insert an "Ending Miles" column and then finally a  "Total Miles Driven" column. To me that formula would need to calculated the sum of two entries and then yield a result of the number of miles for that trip. 

I.e. - Beginning Miles = 100 Ending Miles 150 and a result of 50 Miles driven.  

I have come close a few times but I keep getting just the sum of the two columns together. 

Thanks for your help on this.

 

Dennis

Andrée Starå

Hi Dennis,

Try this.

=[Ending Miles]@row - [Beginning Miles]@row

Did it work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting