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? – MARK MY ANSWER 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? – MARK MY ANSWER 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 acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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