Sum only the latest value
Hello,
I have a sheet that updates values of a certain id through a form.
I want to add the last values of each id.
Thank you
Best Answer
-
Here's one way to do it.
Add a helper column called MaxValue with this formula:
=IF(Date@row = MAX(COLLECT(Date:Date, ID:ID, ID@row)), Value@row)
Then your sum formula will be: =SUM(MaxValue:MaxValue)
I hope this helps.
Cheers,
Ramzi
Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
Answers
-
Here's one way to do it.
Add a helper column called MaxValue with this formula:
=IF(Date@row = MAX(COLLECT(Date:Date, ID:ID, ID@row)), Value@row)
Then your sum formula will be: =SUM(MaxValue:MaxValue)
I hope this helps.
Cheers,
Ramzi
Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
-
Great!! Thank you Ramzi
Help Article Resources
Categories
Check out the Formula Handbook template!
