Use SUMIFs if you have 2007

If not, try;
=SUM(SUMIF($A$1:$A$10,1,$B$1:$B$10),
SUMIF($A$1:$A$10,2,$B$1:$B$10),
SUMIF($A$1:$A$10,3,$B$1:$B$10))


Other ways here
http://www.ozgrid.com/Excel/sum-if.htm



--
Regards
Dave Hawley
www.ozgrid.com
"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?