WoW Characters.xlsx
On line 2, the =Sum(B2:L2) is 15+15+15+15+30 and results in 30 being answer when it should be 90. then the next formula =IMSUM(M2,O2) should be 90 -8=82 but actually says 30-8=0. I am having issues finding out where the issue is and this is a multipage program I am working on even retyping it over and over. If anyone is able to help find the issue, it would be much appreciated. Thank you. I attempted to attach the file.
There is nothing wrong with your SUM() formula. The problem is that you have a circular error, on sheet2 B2:B3. Remove that range (which is trying to sum a bunch of text anyway??) and the formulas work just fine
also, on a side note in sheet1 D2, you have this...
=IF(OR(Declah!B2="0"),"",Declah!B2)
an OR statement takes at least 2 arguments, but in this case seems unnecessary? Perhaps just...
=IF(Declah!B2=0,"",Declah!B2)
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
Just correct this one then the issue will get resolved
In Lansalot sheet
B2 cell formula should be
=SUM(C2:AH2)
Drag it down...
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thanks a lot everyone. Don't know how I missed that.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks