View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Blackstar79
 
Posts: n/a
Default omiting cells in average calcs

how do i calculate average of cells but only if certain cells say something.
ex:
average of cells A1,A11,A12,A14. average of those cells but for cell A14
only include it in the average calculation if cell A13 has "x". if "x" is not
present in cell A13 then only calculate the average of A1,A11,A12 & omit
results of cell A14.