route217
asked on
#value error when summing rows above
Hi Expert's excel 2007
I have formula in cell a2:a9 index match..which work fine..how every when I insert in riw a11 =sum (a1+a3+a5+a7+a9)...if the rows above are blank then cell a11 retruns #value error as opposed to blank.
I have formula in cell a2:a9 index match..which work fine..how every when I insert in riw a11 =sum (a1+a3+a5+a7+a9)...if the rows above are blank then cell a11 retruns #value error as opposed to blank.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thank you andrew,
I have also seen the method using the "+" cause the results being seen if there is non-numeric data in a cell where using the "," will normally correct it.
Even Microsoft has an article about it: http://office.microsoft.com/en-us/excel-help/correct-a-value-error-HP010342330.aspx
I have also seen the method using the "+" cause the results being seen if there is non-numeric data in a cell where using the "," will normally correct it.
Even Microsoft has an article about it: http://office.microsoft.com/en-us/excel-help/correct-a-value-error-HP010342330.aspx
ASKER