Use array to get the total sum meeting some criteria?

[BNCOXUK]

Just got a small question

I want to use an array plus some match-up to get the total sum (in column) for cases in column A that also exist in column C. In this example, DEF and XYZ exist in column C. So the total sum is 2+3=5.

image001.png

[Jakobshavn]

In D1 enter:

=IF(COUNTIF($C$1:$C$1000,A1)>0,B1,"") and copy down and then use:

=SUM(D:D)

[BNCOXUK]

Thanks for the formula. Can we have one single formula in a cell to get the result?

[ConneXionLost]

Use this array formula:

Please Login or Register  to view this content.

Confirm as an array with Ctrl-Shift-Enter.

[BNCOXUK]

Thanks, ConneXionLost. This is really nice