Hello,
I'm trying to show the total weight lost in a work group competition since the last weigh-in.
I cannot figure out how to add all of the weight lost by each individual without creating a column to do so.
I tried an array with ={X4:X35-K4:K35} which didn't give the correct value.
Sum differences between relative values of the above ranges without having to explicitly use =sum(x4-k4,x5-k5, etc). I hope this makes sense. I'm unable to post HTML code.
Bookmarks