For those not using SQL Server 2012 or above, a cursor is likely the most efficient supported and guaranteed method outside of CLR. There are other approaches such as the “quirky update” which can be marginally faster but not guaranteed to work in the future, and of course set-based approaches with hyperbolic performance profiles as … Read more
Using a correlated query: SELECT t.id, t.count, (SELECT SUM(x.count) FROM TABLE x WHERE x.id <= t.id) AS cumulative_sum FROM TABLE t ORDER BY t.id Using MySQL variables: SELECT t.id, t.count, @running_total := @running_total + t.count AS cumulative_sum FROM TABLE t JOIN (SELECT @running_total := 0) r ORDER BY t.id Note: The JOIN (SELECT @running_total := … Read more
Update, if you are running SQL Server 2012 see: https://stackoverflow.com/a/10309947 The problem is that the SQL Server implementation of the Over clause is somewhat limited. Oracle (and ANSI-SQL) allow you to do things like: SELECT somedate, somevalue, SUM(somevalue) OVER(ORDER BY somedate ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS RunningTotal FROM Table SQL Server gives … Read more
Remove contents of column C and then try in C1 this formula =ArrayFormula((IF(LEN(B1:B), SUMIF(ROW(B1:B),”<=”&ROW(B1:B),B1:B),)))