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

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?


--
tommot82
------------------------------------------------------------------------
tommot82's Profile: http://www.excelforum.com/member.php...o&userid=35252
View this thread: http://www.excelforum.com/showthread...hreadid=550258

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

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

Andy.

"tommot82" wrote in
message ...

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?


--
tommot82
------------------------------------------------------------------------
tommot82's Profile:
http://www.excelforum.com/member.php...o&userid=35252
View this thread: http://www.excelforum.com/showthread...hreadid=550258