Support Board
Date/Time: Thu, 13 Feb 2025 13:56:22 +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) |