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

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
You must log in or register to reply here.

Similar threads

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

Forum statistics

Threads
1,224,823
Messages
6,181,177
Members
453,021
Latest member
Justyna P

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