SUMPRODUCT(SUMIF or other clever solution!

Hello Guys!

What I need is a dynamic list in sheet TCO M2:M44 with unique values from sheet GE G3:G45, no blanks.
In sheet TCO N2:N44 this will look up the value in the adjacent M row and find this value in sheet GE G3:G45 and then all values in the adjacent B row.
The values in sheet GE B3:B45 will then be looked up in sheet MCO C:K and return the adjacent qty (1 column to the right) for each result summed up, but only if A column has 2012.
The end result will be displayed in sheet TCO N2:N44, preferably without helper columns, and no VBA

Ex: The result for sheet TCO M2 should be 11013302, and N2 should be 0
The result for sheet TCO M4 should be 11022316, and N4 should be 23

Workbook.xlsx

Best Regards
Torleif

Great work NBVC!

I changed TCO! N2 to:

=IF(M2="","",SUMIF(GE!$G$3:$G$27,M2,GE!$C$3:$C$27))

And now i get the correct values
Is there anyway to ship the "helper column" GE!C:C ?

BR
Torleif

Amazing NBVC!

Works perfectly, thanks alot!

BR
Torleif

Hello again!

My formula has now evolved to this:

Please Login or Register  to view this content.

My problem is that it does not include duplicates in Gears!$H$3:$H$50.
Is there any solution to this? I have been trying to implement this formula:

Please Login or Register  to view this content.

, but with no luck.
There are now up to 5 duplicates in Gears!$H$3:$H$50, this could increase.

Best Regards
Torleif

Thanks alot NBVC!

A small adjustment and it works perfectly! :D

Best Regards
Torleif