# Is there a more elegant way to cross-average?

#### ostrom808

##### New Member
The big boss wants to average all combinations of 2 sets of 3 numbers - so he wants the average of 485 and 952; 485 and 740; and 485 and 219, for example. We started off with the plain old =AVERAGE(\$A4,B\$3) and filled in the rest of the cells. But he wanted something like a pivot table (????) or a matrix function from linear algebra (????). Any help would be greatly appreciated!

...........952 740 219
485
210
357

We're using Excel 2003 and Windows XP.

### Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

#### Gerald Higgins

##### Well-known Member
Well it sounds like you need to clarify exactly what HE wants.

#### ostrom808

##### New Member
This is the answer he wanted. And we got it by using the simple average formula. But is there a cooler / fancier / more elegant way? Thanks!

...............952 740 219
485 718.5 612.5 352.0
210 581.0 475.0 214.5
357 654.5 548.5 288.0

#### tigger6333

##### New Member
For your example of

952 740 219
485
210
357

I assumed 952 was in B1, 740 in C1, 219 in D1
485 in A2, 210 in A3, 357 in A4

So in cell B2 put the formula =AVERAGE(\$A2,B\$1) and copy across and down.

Woohoohoohoooooo!

The Tig

Replies
3
Views
592

1,133,427
Messages
5,658,732
Members
418,467
Latest member
sc356448

### 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?

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