Sumproduct
Hello, I haven't managed to get this to work, maybe someone can help me with
the formula... I want to get the sum when it meets 2 criteria. I will fill
with this a table that has on x-axis: Month on y-axis: Supplier.
Month should be taken from Sheet: 2007, Column: Y
Supplier from Sheet: 2007, Column: I
and the amount added is Column: K
They are as a range, not as a table.
,thanks
|