If N/A has been entered as text (not from a formula), the =AVERAGE(A1:A7)
will ignore it

If you have NA() as part of a formula that is returning N/A:
Option 1
=AVERAGE(IF(ISNUMBER(C1:C7),C1:C7))
Array formula: you must commit it with Shift+Ctrl+Enter not just Enter
Option 2 Non array formula
=SUMIF(D1:D7,"0")/COUNTIF(D1:D7,"0")
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Erinayn" wrote in message
...
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!