Thread: calculate average in a column based on criteria in another column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sharon t
 
Posts: n/a
Default calculate average in a column based on criteria in another column
I want to calculate the average of numbers in one column based on crieteria
in another colume.

If the value in column A = x, sum and average the corresponding values in
column B
Reply With QuoteReply With Quote