Login Page - Create Account

Support Board


Date/Time: Sat, 18 May 2024 06:01:27 +0000



Post From: Help with a Spreadsheet Sum column upon a condition then start from 0

[2020-12-06 16:35:48]
User215984 - Posts: 24
Thanks!

I found this on the web for Excel and it does what I need. Could it be converted for the SC spreadsheet?

=SUM($A$2:A2)-IFERROR(SUM(OFFSET($A$1,1,0,MATCH(LOOKUP(2,1/($C$2:C2>0),$C$2:C2),$C$2:C2,0)-1,1)),0)
imageS-3.JPG / V - Attached On 2020-12-06 16:35:32 UTC - Size: 30.2 KB - 181 views