Thread: averages
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Metolius Dad
 
Posts: n/a
Default averages

Dear Wizards,

Col A has 200 - 300 entries randomly occuring limited to the integers 0-19.
Col B has numeric values. What formula can I use to figure the average of
all of col B's values that are accross from (associated with) a col A value
of '7' then '8' then '9' etc.

Thanks for being there.
Sam