simple sumifs not working

[snjpverma]

I fail to understand why the below formulas give different results.

When I do the calculation manually, the SUMPRODUCT seems to be giving the correct result.

=SUMIFS(J1:J1000,K1:K1000,"<>Pending")

Result is 43505

=SUMPRODUCT(--(K1:K1000<>"Pending"),J1:J1000)

Result is 53595

 

[Aladin Akyurek]

They should not differ...

Care to produce the file or the sample where the difference obtains?