Do you mean, A, C and E say (that is regularly spaced),

=SUMPRODUCT(--(MOD(COLUMN(A2:E2),2)=1),--(A2:E20),--(A2:E2<1),A2:E2)/SUMPRO
DUCT(--(MOD(COLUMN(A2:E2),2)=1),--(A2:E20),--(A2:E2<1))


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

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