2

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 '19 at 19:20
  • @MARKMYANSWER, I want to calculate the variance manually (I am aware of the VAR function). Thank you. Feb 4 '19 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 '19 at 19:29
1

=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, privacy policy and cookie policy

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