Is there a more elegant way to cross-average?

ostrom808

New Member
Joined
May 24, 2006
Messages
10
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.
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

ostrom808

New Member
Joined
May 24, 2006
Messages
10
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
Joined
Sep 6, 2009
Messages
43
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
 

Watch MrExcel Video

Forum statistics

Threads
1,102,363
Messages
5,486,412
Members
407,547
Latest member
Sankarasrinivas

This Week's Hot Topics

Top