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