How do you arrayformula() a sum() such as:
arrayformula()
sum()
=sum(A1:H1)
I need to go down 1000 rows.
Another option:
=ArrayFormula(SUMIF(IF(COLUMN(A1:H1),ROW(A1:A1000)),ROW(A1:A1000),A1:H1000))
1.4m articles
1.4m replys
5 comments
57.0k users