average(if())
I bet you need this
=IF(AND(A2:C20,A2:C2<1),AVERAGE(A2:C2),"")
(press control + shift + enter to enter it and get the curly brackets)
--
Allllen
"neversummer" wrote:
(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.
|