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

Sumproduct
 

Ed,

Not sure what you want to do, as your explanation is not very clear.
Do I understand that you want to make a table with Month versus Supplier out
of a list/range in your sheet 2007?
If that is the case, can I recommend you use a pivot table?
Look under Data - Pivot Table, select the range that you want (including
column I, K, and Y) and click through. Once done, drag the Month header to
the top line and the supplier header to the column side. Last but not least
drag the amount to the data area, and I guess that is what you need.
Make sure that all columns in your pivot table datarange have unique
headers, otherwise it won't allow you to make a pivot table. Good luck. Rob

"Ed" wrote:

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

Sumproduct
 

=SUMPRODUCT(--(MONTH(Y2:Y200)=12),--(I2:I200="supplier"),K2:K200)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Ed" wrote in message
...
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

Sumproduct
 

Thanks, both solutions work for me

,Ed