Sum if 2 variables
Perfect - thanks a lot!
What are the hypens in the formula for? (--(A1...
"Jacob Skaria" wrote:
Try with SUMPRODUCT
=SUMPRODUCT(--(A1:A100="Period"),--(B1:B100="customer"),C1:C100)
If this post helps click Yes
---------------
Jacob Skaria
"ksel" wrote:
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
|