Blended average % formula Excel 2010

S

Smudge80

New Member
Joined
Sep 26, 2018
Messages
17
Hi Everyone,

Have a table of percentages from ranges C3:R3 C4:R4 C5:R5 that I require to be filled with the average percentage of another 3 ranges C7:R7 C8:R8 C9:R9.
Thee 3 ranges all total 100% and I require fist set of ranges to equal the same.

Many thanks in advance.
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
You must log in or register to reply here.

Similar threads

V
  • Solved
Average Function
Replies
8
Views
381
Peter_SSs
Peter_SSs
JenniferMurphy
  • Question Question
I could use help with a bit of a complex table addressing problem
Replies
1
Views
213
JenniferMurphy
JenniferMurphy
V
  • Solved
Formula to calculate automatically progressive average
Replies
5
Views
499
etaf
etaf
M
  • Solved
move and delete rows contains minus and positive value from range to another
Replies
8
Views
80
Mussa
M
D
  • Question Question
Automating selecting cells to create average
Replies
2
Views
576
Draff
D

Forum statistics

Threads
1,223,903
Messages
6,175,284
Members
452,630
Latest member
OdubiYouth

Share this page

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top