View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Excel_Learner Excel_Learner is offline
external usenet poster
 
Posts: 53
Default Conditional Average

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.