Solved: Formula Help - SUM

[Juicey27]

Excel 2007
I have a formula in a cell that caculates the sum based on all eight questions being answered. What I would like my formula to do is: If one or more of the eight questions is not answered, that my formula readjust and divides by the new number. (The number of actual answered questions.)

My current formula:
=SUM(G4:N4)/8

[mancubus]

try

=SUM(G4:N4)/COUNT(G4:N4)

[Juicey27]

This works. Had to correlate this with a userform. Works out prefecto. Thanks for all your help.