As you stated, you did get a response which addressed the "alpha N/A". The
response was that Average will ignore text. Now you have to explain why that
doesn't work for you, and what you mean by "the average is of nothing".

Regards,
Fred

"Erinayn" wrote in message
...
It is just an alpha N/A. Now that I'm looking at it only one person has
responded as such and the kicker is that no other responses for the area
were
received so I'm getting an error since the average is of nothing.

Any thoughts on that?

"Dave Peterson" wrote:

If you really have N/A (plain old text) in that cell, then
=average(a1:a6)
should work fine.

=average() ignores non-numeric (but not errors) values.

On the other hand, if you have the error #N/A (resulting from a
formula???) in
that range, then =average() will return an error.

You could use:
=SUMIF(A1:A6,"<1e37")/COUNT(A1:A6)

1E37 in scientific notation for a giant number. 1 followed by 37 zeros.



Erinayn wrote:

I have a 7 question survery with the following possible responses
1
2
3
4
5
N/A
We then take ther responses and average them. I'd like to eliminate the
N/A
responses from the denominator and from the total sum. I currently have
1
cell for this operation - which doesn't work when the response is N/A
since
it's a simple (sum)/7 equation.

Thanks for any help!

--

Dave Peterson
.