5

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).

3
  • what formula you want to apply?
    – user0
    Feb 4, 2019 at 19:20
  • @MARKMYANSWER, I want to calculate the variance manually (I am aware of the VAR function). Thank you. Feb 4, 2019 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, 2019 at 19:29

1 Answer 1

3

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


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

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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