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))
2.1m questions
2.1m answers
60 comments
56.9k users