Forum Discussion
Need Help with a Formula to find difference in cell range
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!
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.
