Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
average(if())
(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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there any way to get an AVERAGEIF & MEDIANIF function in Exce | Excel Worksheet Functions | |||
averageif | Excel Discussion (Misc queries) | |||
how can i calc averageif | Excel Worksheet Functions | |||
"AverageIF" alternative | Excel Discussion (Misc queries) | |||
AVERAGEIF Function out there? | Excel Discussion (Misc queries) |