A B C a 3 d b 1 a c 8 e d 5
I want to use
SUMIFS function, sum range is
B1:B4, if the corresponding value in column
A exists in column
C, sum the values in column
in this case the sum will be
3 + 5 = 8
=SUMIFS(B1:B4,A1:A4, COUNTIF($C$1:$C$3,A1) but I get zero.
Link for further reading: <a href="https://web.archive.org/web/20141014072615/https://excelxor.com/2014/09/02/countifs-multiple-or-criteria-for-one-or-two-criteria_ranges/" rel="nofollow">COUNTIFS: Multiple “OR” Criteria For One Or Two Criteria_Ranges</a>Answer2:
What you want is this:
I know you asked for a sumif, but that doesn't want to work, entering the below as an array formula (
CTRL+SHIFT+ENTER) does the trick.