How do I subtotal the same items from one sheet into another?
 

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.

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.

How do I subtotal the same items from one sheet into another?
 

There is a SUMIF function or doesn't this work in your instance?

"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.