D
D
Dima2019-12-21 15:12:33
Google Sheets
Dima, 2019-12-21 15:12:33

How to apply percentage formula to other cells?

There are 2 columns, in one the sum of all values, and in the other the percentage of the number from the first column from the sum of the values.
5dfe0b23df9bc356517520.png
Example table
I want to apply the formula from the second column =A2/A1to other cells, but the system does not apply it correctly. Instead, it replaces the cell number of the denominator with the digit of the cell to which the formula is applied. It turns out something like this.
5dfe0bb436424122901271.png
And it is necessary that it be so
5dfe0c1d0aaac955015817.png
How to fix it?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
dollar, 2019-12-21
@qpz

=A2/A$1
Then stretch (apply) as usual.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question