Thread: average with mulitple ciriteria
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ellebelle
 
Posts: n/a
Default average with mulitple ciriteria
I want to get the average with two criteria. if the cells in column Z = B11
then I want the average value from column CA (BUT I only want the average of
cells greater than zero.)
Reply With QuoteReply With Quote