# Simple =Sum(B2:L2) result is not giving accurate result and =IMSUM(M2,O2) also.

1. ## Simple =Sum(B2:L2) result is not giving accurate result and =IMSUM(M2,O2) also.

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.  Register To Reply

2. ## Re: Simple =Sum(B2:L2) result is not giving accurate result and =IMSUM(M2,O2) also.

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)  Register To Reply

3. ## Re: Simple =Sum(B2:L2) result is not giving accurate result and =IMSUM(M2,O2) also.

Just correct this one then the issue will get resolved In Lansalot sheet

B2 cell formula should be
=SUM(C2:AH2)

Drag it down...  Register To Reply

4. ## Re: Simple =Sum(B2:L2) result is not giving accurate result and =IMSUM(M2,O2) also.

Thanks a lot everyone. Don't know how I missed that.  Register To Reply