wrt1mea
asked on
I need an excel formula
I need an excel formula to average values in column A only if they are equal to or greater than 1.
I tried the following but it seems that its not correctly averaging if there a negative values.
=average(A:A>=1,A:A). See attached.
9-30-11.xlsx
I tried the following but it seems that its not correctly averaging if there a negative values.
=average(A:A>=1,A:A). See attached.
9-30-11.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
See attached, also includes this formula to give the same result
=AVERAGE(IF(A1:A100>=1,A1: A100))
which is an array formula which needs to be confirmed with CTRL+SHIFT+ENTER
You'd need that to be compatible with Excel 2003 and earlier versions
regards, barry
27373868.xlsx
=AVERAGE(IF(A1:A100>=1,A1:
which is an array formula which needs to be confirmed with CTRL+SHIFT+ENTER
You'd need that to be compatible with Excel 2003 and earlier versions
regards, barry
27373868.xlsx
ASKER
Perfect!
ASKER