Forum Discussion
CullenW
May 24, 2024Copper Contributor
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 th...
Riny_van_Eekelen
May 24, 2024Platinum Contributor
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.