Hi everyone,

I have a weird problem with SUMIF formula.

My formula in cell R1046 is :

So, the basic is :

If column C contains the value of the regarding row then calculate the value of column L.

As we can see, inside the blue box - Excel calculate those 12 selected rows of column L correctly.

But the formula say that it's "not paid" as it should say "paid".

The next image below :

So I select L1046 cell, and then put the cursor in the formula bar, and then hit ENTER....

Now... the formula in R1046 and R1047 calculate correctly which show "paid" as it seen in the image below.

I know I may do the same for the rest of the row in order the formula calculate correctly,

but it's going to be tedious as there are thousands of rows that I should do the same thing repeatedly.

The next image show a weird result of the formula in R1048 and R1049 after I omit the IF formula....

so the formula in R column is as seen as in the formula bar of the image below :

And again, if I select L1048 cell, then put the cursor in the formula bar then hit ENTER,

the formula in R1048 and R1049 calculate correctly where the result is 0 (zero).

If I did something wrong when inputting the value in column L,

but then why Excel inside the blue box of the first image can calculate it correctly ?

Now my question is :

Why did Excel SUMIF formula not calculate correctly in my case ?

What did I do wrong before ?

BTW, I've tried (again and again) formatting the L column to "number" but no luck.

Any kind of respond will be greatly appreciated.

Thank you in advanced.

regards.

I have a weird problem with SUMIF formula.

My formula in cell R1046 is :

Code:

`=IF(SUMIF(C:C,C1046,L:L)=0,"paid","not paid"`

So, the basic is :

If column C contains the value of the regarding row then calculate the value of column L.

As we can see, inside the blue box - Excel calculate those 12 selected rows of column L correctly.

But the formula say that it's "not paid" as it should say "paid".

The next image below :

So I select L1046 cell, and then put the cursor in the formula bar, and then hit ENTER....

Now... the formula in R1046 and R1047 calculate correctly which show "paid" as it seen in the image below.

I know I may do the same for the rest of the row in order the formula calculate correctly,

but it's going to be tedious as there are thousands of rows that I should do the same thing repeatedly.

The next image show a weird result of the formula in R1048 and R1049 after I omit the IF formula....

so the formula in R column is as seen as in the formula bar of the image below :

And again, if I select L1048 cell, then put the cursor in the formula bar then hit ENTER,

the formula in R1048 and R1049 calculate correctly where the result is 0 (zero).

If I did something wrong when inputting the value in column L,

but then why Excel inside the blue box of the first image can calculate it correctly ?

Now my question is :

Why did Excel SUMIF formula not calculate correctly in my case ?

What did I do wrong before ?

BTW, I've tried (again and again) formatting the L column to "number" but no luck.

Any kind of respond will be greatly appreciated.

Thank you in advanced.

regards.

Last edited: