Sumifs returning 0 for crieria existing

[sevas1994]

Hi there,

In column A, I have IDs which are not unique, B date, C description, and D amount. In cell E1 I wrote 250000 which far above the maximum amount in column D, in E2 I wrote E1+ 1 and extended the formula to the non blank last cell. I am trying to get a list of duplicate items. I wrote the following formula in cell F1: =sumifs(E:E, A:A, A1, B:B, B1, C:C, C1, D:D, D1) and I get zeros in F column. But why? It doesn't make any sense. It can,t sum values existing?

Many thanks in advance

 

[Joe4]

Duplicate. Handling same issue you brought up here: Countifs returning 0 for items being searched in where they exist

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #12 here: Forum Rules).