Averageifs help

[Bencreamer]

I need help using averageifs formula. I need to find the average of a group of percentages greater than zero and less than 200%.
I have used: averageif(J7:J28,">2") but I need to exclude zeros or any other value or error message (#value!). Any help would be appreciated.

 

[Eric W]

=averageifs(j7:j28,j7:j28,">0",j7:j28,"<2")

 

[Bencreamer]

Thank you!

 

[Eric W]

You're welcome, and thanks for the feedback!