1

How could I apply a formula to each cell in a column before computing a sum of the cells in Google spreadsheet?

In other words, I have a column of cells with numbers. And what I want is to iterate over each row in the column (i.e. each cell), apply a formula to the number in the cell and get a result of the formula. Then I want to sum all of those results.

And all of this I would like to perform in one cell (i.e. in one query).

  • what formula you want to apply? – user0 Feb 4 at 19:20
  • @MARKMYANSWER, I want to calculate the variance manually (I am aware of the VAR function). Thank you. – iamyourfriend Feb 4 at 19:22
  • I wasn't referring to VAR function... you say: "apply a formula to the number in the cell and get a result of the formula. Then I want to sum all of those results." and I ask: what formula you want to apply to the number in the cell before you sum the results of this application? – user0 Feb 4 at 19:29
0

=SUM(ARRAYFORMULA((B2:B26-$B$1)^2))/A1


=SUM(ARRAYFORMULA(A1:A4*(SUM(2, 3))))

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.