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.

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)

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

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.

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1