View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
barry houdini[_4_] barry houdini[_4_] is offline
external usenet poster
 
Posts: 57
Default 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)