SUMIF gives wrong result (not in range)

DavidPonnet

New Member
Joined
Mar 16, 2017
Messages
23
when using sumif in this example, I get the wrong result. It even adds values from out of the range (see picture)

Cell B78 is never in the range, yet it adds it to the result of cell BL78

I have been trying to look for the error all day, and just found this, but can not explain this.

9
9
view.php
16ack0z.jpg


(the formula was originally from another sheet, but I changed the criteria to show the ranges. The results are the same for all things I try

Another thing, when I change the value of cell A78 to fe. "A", the result is correct, another mindbogling things I cant wrap my head around...

If ANY one could help me out, that would be great !!!
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
Its just the way SUMIF works. See if this produces the same result (add sheet names first)

=SUMIF(A78:BM85,A78,BL78:DX85)

Try it with a SUMIFS and you will see it errors. It has to have the same number of cells to test as it has to sum if the test is true.
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,177
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top