Is There an Average IF?

  • Thread starter Thread starter Dave N
  • Start date Start date
D

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.
 
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 **
 
Back
Top