Sum issue

T

Tim Hill

I have 2 sheets in a workbook, one with data on what orders per store we're
dispatching a day, this sheet directly relates to another which is aware of
what packaging we're using, trays or boxes. At the bottom of each store order
i'm trying to total up both individually. Is there a way of doing a sum which
will be able to know the difference of which product goes into which
packaging and add them up seperately

To explain how the sheets are spread out,

Sheet one, A4:A12 Product Code (directly relates to sheet 2, which has a
column of product type in). B4:B12 - which has number of products ordered and
C4:C12 which is a conditional Vlookup related to A4:A12.

Sheet two, A1:A27 which is the list of product codes (which sheet one uses),
B1:B27 is a list of products which is automatically placed into sheet one
C4:C12 dependant on sheet one's figure placed into A4:A12. K1:K27 is the list
of packaging type.

I'm trying to make C13 count the number of products which are in trays and
C14 the number of products in boxes, as I can't do a simple sum of B4:B12.

I suppose i'm really trying to find out if theres a way of excel knowing
whats in a box and whats in a tray and adding them up independantly?
 
J

JBoulton

Tim,

I don't have a good picture of your data, but this may help you.

=SUMPRODUCT(--(RangeOfTypes="trays")) will count the number of "trays" in
the range. Substitute "boxes" in the formula and that will give you the
other count you're looking for.

Good Luck,
Jim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top