Is There an Average IF?

[Dave N]

I want to average a row of numbers but exclude any cell
with a value of 1 or less. I tried to do a function with a
COUNTIF, but my cell range is not consecutive.

 

[Paul B]

Dave, try something like this

=AVERAGE(IF(A1:A16<>1,A1:A16))

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **