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,...
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.