One way...

=SUM(SUMIF(A2:A100,{1,3,7},B2:B100))

--
Biff
Microsoft Excel MVP


"Tom" wrote in message
...
Have a column for item id and a column for its Qty. What I need to do is
have
a sum of all the item id quanitities whose item id is either a 1, a 3, or
a
7. If it was just that I needed the sum of those with 1 I could use SumIf.
But what if I want a combined total of certain id's?