--
Thank you for your time!
John


"Gary''s Student" wrote:

=IF(ISERROR(AVERAGEIF(A1:A5,"2")),0,AVERAGEIF(A1: A5,"2"))
--
Gary''s Student - gsnu201001


"Very Basic User" wrote:

I have two questions.

1. When using AVERAGEIF... actual line =AVERAGEIF(A1:A5,"2") this works
great unless all values = 0 then I get #DIV/0!. I would like to have the
value remain 0 (The greater than 2 is because we have a +;- 2 standard error
in our insequel pull of information. How would I correct the error message?

2. When using AVERAGEIF for cells not in a range...actual line
=AVERAGEIF(A1,A5,A6,"2") this formula is not acceptable at all. Any way to
do this?
--
Thank you for your time!
John