View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
duane duane is offline
external usenet poster
 
Posts: 64
Default How do I subtotal the same items from one sheet into another?

try sumif function (with only once criteria such as a part number) or
sumproduct function if you need more than one critieria.

"Richard" wrote:

I have a list of all the sales orders for the month. I want to Subtotal
certain part numbers from that sheet into another. Vlookup doesn't seem to
work for this. Is there another function that will do this.