Conditional Average
Try,
=SUMIF(A2:A6,"=A",B2:B6)/COUNTIF(A2:A6,"=A")
Change the A to the state you want.
Mike
"Excel_Learner" wrote:
can anybody please help me out?
I have a worksheet with below mentioned details:
State Qty
A 50
A 60
A
B 70
B 65
Now i need average of every state.
Please help.
|