Thread: Sumproduct
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ed Ed is offline
external usenet poster
 
Posts: 279
Default 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