Need Help with a Formula to find difference in cell range

Copper Contributor

Need help figuring out a formula for calculating weight lost/gained over a cell range.  Very beginner level knowledge on my end so I'm struggling with a formula to add/subtract the difference from the starting weight on 3/25/24 in cell C5 to the ending weight on 6/21/24 in cell F5.  I need just the total weight lost/gained summed in cell G5. 

 

Example: someone starts at 200, goes to 190, back to 195, then finishes at 185, how do I capture that fluctuation in a formula? 

 

Screen shot below.  Thanks in advance for any help! 

 

Screen Grab BL.png

1 Reply

@CullenW In G5, enter:

=C5-INDEX(C5:F5,1,COUNT(C5:F5))

and copy it all the way down. That takes the Start weight and deducts the weight that is entered last.

 

Example attached.