Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum if 2 variables
Hi, in 1 column I have the name of periods (1 year = 13 periods of 4 weeks:
Period 1, Period 2 etc) and in another column I have the name of customers (cmr 1, cmr 2 etc). A third column has the weight of product sold to that customer. Now I would like to see how much weight was sold to every customer per period: if you see "Period 1" in column 1, count weight if you see "cmr 1". In the result, the customer's name is sorted vertically, the periods horizontally... I tried with SUMIF, but then I have to change the ranges for every period... Thanks a lot for suggestions, Kristoff |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Not at all clear on use of variables and/or object variables | Excel Discussion (Misc queries) | |||
Three Variables | Excel Worksheet Functions | |||
Too many variables? | Excel Worksheet Functions | |||
Using variables in a name | Excel Discussion (Misc queries) | |||
SUM IF and two variables | Excel Worksheet Functions |