SUMIF using criteria from a list
Hello Kevin
You can use SUMIF like this
=SUM(SUMIF(A$2:A$9,{102,104,107},B$2:B$9))
or, if you have a list of accounts in F2:F15 as Pete suggests
=SUMPRODUCT(SUMIF(A$2:A$9,F2:F15,B$2:B$9))
but be careful with that one because if any account is repeated in
F2:F15 you'll double count it. To avoid that try
=SUMPRODUCT(--ISNUMBER(MATCH(A$2:A$9,F2:F15,0)),B$2:B$9)
|