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),)))
More Related Contents:
- QUERY and order by the first date of column
- ArrayFormula of Average on Infinite Truly Dynamic Range in Google Sheets
- Import data into Google Colaboratory
- Conditional formatting based on another cell’s value
- Google Sheets importXML Returns Empty Value
- How to stop / freeze / pause volatile RAND / RANDBETWEEN / RANDARRAY?
- How to SUM duration in Google Sheets?
- Conditional Formatting from another sheet
- New Google Spreadsheets publish limitation
- ArrayFormula and “AND” Formula in Google Sheets
- ARRAY_LITERAL, an Array Literal was missing values for one or more rows
- Query is ignoring string (non numeric) value
- Repeat whole row N times based on column value in Google Sheets
- I get Formula parse error with all formulas
- Generate all possible combinations for Columns(cross join or Cartesian product)
- Download link for Google Spreadsheets CSV export – with Multiple Sheets
- IMPORTXML and right XPath from Bloomberg price [duplicate]
- What factors determine the memory used in lambda functions?
- How to list all permutations without repetition?
- How to use arrayformula with formulas that do not seem to support arrayformulas?
- Repeat each row N times in Google Sheets
- How to create all possible pair combinations without duplicates in Google Sheets?
- Stacking multiple columns on to one?
- New Google spreadsheet Concatenate limit 50000 characters
- Col BY causing parse error in Google sheets query
- Count cells that contain any text
- How to make a range repeat n-times in Google SpreadSheet
- In ARRAY_LITERAL, an Array Literal was missing values for one or more rows – indirect formula error in google spreadsheet
- How to Print sheet/range using .gs script in Google Sheets?
- Google Sheets QUERY Function: Select Columns by Name