Thread: 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.

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.

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.