Hi,

Try it this way

=SUM(A1:A7)/COUNT(A1:A7)

Mike

"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!