CODEWITHSUNDEEP
excelexcel-formula
mj828
mj828

Reputation: 63

Excel - I am trying to SUM values in a column if the values in a corresponding column equal the values in another column

In Excel I am trying to SUM values in a column if the values in a corresponding column equal the values in another column.

If the values in Column K (Fig 1) are found in Column F (Fig 2), SUM all the corresponding values of column L (Fig 1) in Z2 (Fig 3).

=SUMIF(K:K,F:F,L:L) is not giving me what I need.

Fig 1

Fig 2

Fig 2

Fig 3

Fig 3

Fig 1

Upvotes: 0

Views: 1039

Answers (1)

Qualia Communications
Qualia Communications

Reputation: 715

SUMIF provides an array of values, which would spill over to the follwing rows. If you wrap it in SUM, you should get the desired result.

=SUM(SUMIFS(L:L,K:K,F:F))

enter image description here

Side note: I prefer using SUMIFS over SUMIF, but both should work.

Upvotes: 2

Related Questions