Juicey27
02-28-2011, 07:47 AM
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
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