arrayformula sum in Google spreadsheet November 22, 2023 by Tarik Another option: =ArrayFormula(SUMIF(IF(COLUMN(A1:H1),ROW(A1:A1000)),ROW(A1:A1000),A1:H1000))