View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tom tom is offline
external usenet poster
 
Posts: 570
Default Sum Formula dilemma - Can yu Solve?

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?