anyway to do this if the data to be averaged is not in adjacent columns??

"neversummer" wrote:

that worked like a charm! thanks a ton. if i may....
what does the * do in this situation, is it like an either/or, so if i got
crazy and wanted to continue with the conditions could i add another * ?

cheers

"Biff" wrote:

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?