match sums in 2 column with Sumif returns 0

well your numbers in either or both columns could be text even though they are formatted as numeric, use =isnumber(b2) to see what it returns.

but this might be an easier formula for what you are trying to do... =IF(SUM(C2:C7)=B8,SUM(C2:C7),0)

when you use sumif like that [=SUMIF(D2:D6,B7,B2:B6)] you are saying examine column D rows 2 through 6 for the value found in B7 and if you find it then sum B2 through B6.
sumif looks at a range - in your example D2 through D6 then look for a criteria - in example B7 then if found in D2 through D6 sum the rows in B2 through B6 that have that value.
so essentially you are looking for the value of 7192 (in B7) in the rows of D2 through D6 and if you find it, then sum the values in B2 to B6 that correspond to it.

So if you are trying to find if the sum of the values in col D equal the sum of the values in col B that would be a different formula and that is why your sumif doesn't work in this example.

It definitely helped my understanding. Thanks a lot.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.