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).
VAR
function). Thank you.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?