# Thread: Is there a more elegant way to cross-average? Thanks: 0 Likes: 0

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

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.

2. ## Re: Is there a more elegant way to cross-average?

Well it sounds like you need to clarify exactly what HE wants.

3. ## Re: Is there a more elegant way to cross-average?

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

4. ## Re: Is there a more elegant way to cross-average?

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

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•