Average a group, where grouping is Conditional on other col.???

[tommot82]

Ok, i have what is seemingly an easy problem but i just cant solve its
-simply-

I want to create averages of groupings of data, but the groupings are
conditional on another column

So if my smaple data is below:


Code:
--------------------

col A col B
x 1
x 2
x 3
y 2
y 2
z 4
z 5
z 6
z 7

--------------------


I want to create THREE averages from the data in column B
1) an average for all the data in colB where there is a corresponding
'x' in colA
2) an average for all the data in colB where there is a corresponding
'y' in colA
3) an average for all the data in colB where there is a corresponding
'z' in colA

I cant seem to find an easy answer to this. Can anyone help?

 

[Guest]

Hi
Try something like this:
=SUMIF(A2:A10,"x",B2:B10)/COUNTIF(A2:A10,"x")
Change the "x" as appropriate.

Andy.