LinkBack URL
About LinkBacks
What is the Error in M9 and total field ?
What is the Error in M9 and total field ?
2 options...
1. replace all the +'s with ,'s SUM doesnt need +
2. use this instead...
=SUM('Mdu Rural:Mdu Urban'!M2)
copied down and across as needed
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
i can't understand. can you pls workout and send in my excel sheets
Hi maddyrafi1987- The error is on sheet "Adilabad", where cell M9 contains a " " (space), which is non-numeric. Just delete the space.
Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee
super thanks alot
What I meant was in your SUM functions, dont use the plus sign + use the comma ,Originally Posted by FDibbins
OR replace that big long formula you have with this, instead...
=SUM('Mdu Rural:Mdu Urban'!M2)
Both suggestions will ignore text (which a space is)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks