(sorry about the double post....FNG)

anyway, i am trying to average columns using only the data that falls 0<X1
(between 0 and 1). So if i am averaging cols A:C, sometimes 0A and
sometimes 0C and I want to average only those values in A:C that at that
particular time are 0<X1. have tried the following so far:

{=AVERAGE(IF(and(a2:c20,a2:c2<1,a2:c2,""))}, and
{=AVERAGE(IF(0<a2:c21,a2:c2,""))}

but to no avail :(
help would be greatly appreciated! thanks.