Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum issue
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum issue
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 "Tim Hill" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
issue.... | Excel Discussion (Misc queries) | |||
Sum Issue Help! | Excel Discussion (Misc queries) | |||
IIF issue | Excel Worksheet Functions | |||
DV Issue | Excel Worksheet Functions | |||
IF Issue | Excel Worksheet Functions |