Forum Discussion
How to rectify #value! error..Please help..
Hi sir , can anyone help me to rectify the #value! error?some data is not automatically sumed even apply the correct formula.hereby i attach the file for your understanding.please help me..
Regards,
nbnstat@gmail.com
2 Replies
Updated version attached. As SergeiBaklan said, the spaces (probably generated by formula) were causing the issues. For the cells with the totals / errors, I highlighted the entire range and first did find / replace swapping + for , and then a second find / replace swapping = for =SUM.
In some cells you have spaces which are summed with numbers, thus an error. For example, for
=(B4+B27+B54+B79+B105+B129+B154)B4 is empty and considered as zero, in B27 is space " ", 0+" " returns error. You may use
=SUM(B4,B27,B54,B79,B105,B129,B154)which ignores texts, but better to clean the data.
Plus circular references within workbook, that's another kind of errors.
