All geek questions in one place

Excel averages in multiple columns

I need to take the value in the two columns of data A and C, get the percentage by dividing the current value of columns A and C by the upper value (which is complete), and then average two percent and spit them out in column D. For example, D2 should be (100 (226/508) + (100 (218/490))) / 2). I would prefer to do this with one equation - is this possible?

A       B       C         D
1       508     490

2       226     44.49%    218

3       229     45.08%    221
+3
source share
1 answer

The formula you want

=(100*A2/A$1 + 100 *C2/C$1)/2

and select the whole column D down and then edit-> fill

The relative reference A2 will change in each line to a new line, but A $ 1 will be an absolute link and will remain as the value in line 1.

, . . MS

+2

Source: https://habr.com/ru/post/1784735/

More articles:


All Articles