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

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

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