Thread: average(if())
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
neversummer neversummer is offline
external usenet poster
 
Posts: 4
Default average(if())

My data is in columns. I want to average those values that are 0<X1 only.
Tried using Average(if()) but am so far unsuccessful. Suggestions?