# calculate the % of 2 numbers using Average

#### kylerisi

##### Board Regular
Hi Team

I need to work out the percentage increase or decrease between the number in A and the average of number of A:F

I just dont know how to add this into a formula

I tried the following without any luck

=Sum(A2-(Average(A2:F2)/A2)

However it just seems to error out, Could anyone offer any assistance as to where I am going wrong?

 A B C D E F DEC NOV OCT SET AUG JUL 21 18 16 14 12 2

<tbody>
</tbody>

Thank you so much in advance

Kyle

### Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Use this

=SUM(A2-(AVERAGE(A2:F2)/A2))

let me know if any problem

in G2: =(A2-AVERAGE(A2:F2))/A2

Use this

=SUM(A2-(AVERAGE(A2:F2)/A2))

let me know if any problem

Hi Live_excel,

The formula on its own worked great, so thank you so much, however I was going to adapt the formula and insert into the below formula, however it I cannot seem to get it to work.

Rather than C95 I need to replace this with (AVERAGE(B95:P95)

I cannot seem to get this to work. I was literally just replacing C95 with (AVERAGE(B95:P95), can you see where I am going wrong?

=iferror(if(B95="","",(if(B95>C95, concatenate(" +",text((B95-C95)/C95,"0%"),rept(" ",5),char(9650)),if(B95=C95,concatenate("0%",rept(" ",3),char(9668)," ",char(9658)),concatenate(text((B95-C95)/C95,"0%"),rept(" ",5),char(9660)))))),"◉")

Replies
8
Views
202
Replies
6
Views
435
Replies
25
Views
526
Replies
4
Views
546
Replies
3
Views
205

### Forum statistics

1,203,728
Messages
6,057,021
Members
444,902
Latest member
ExerciseInFutility

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back