Hi guys,
See my sheet here:
https://docs.google.com/spreadsheets...it?usp=sharing
In Cell G13, I want to show much weight is lost by..
Taking the start weight (A11) subtracted by the weight lost which I guess would be the sum of: B11:M11?
Can anyone advise?
thanks!
Thanks,
R.
Your Google sheet is protected.
However, in Excel, it would be this:
=A11-SUM(B11:M11)
So, have you tried that?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
i'm sorry about that Ali.
Unfortunately the solution did not work - however, I have used an add on and summed up the cells which show weight lost (i.e. in green). Thanks for your help anyway!
OK - well, I was going from this:
https://support.google.com/docs/answer/3093669?hl=en
Maybe you need this:
https://support.google.com/docs/answ..._topic=3105474
You did not mention wanting to sum green cells only. My answer would have been very different, had you mentioned this.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks