Thread: average(if())
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Biff Biff is offline
external usenet poster
  
Posts: 1,688
Default average(if())
Try this: (array entered)

=AVERAGE(IF((A2:C20)*(A2:C2<1),A2:C2))

Biff

"neversummer" wrote in message
...
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?


Reply With QuoteReply With Quote