Sumifs - NetSales per product, where the NetSales is in another sheet with product in MultiDropdown

raoul.tserstevens26401

Hello,

I have a Product Sheet and one Transaction Sheet.

I want to calculate the total NetSales in my product sheet (one row per product) by a SUMIF(s) into my transaction sheet knowing that, in there, the product is contained in a multi-dropdown. I tried the following:

=SUMIFS({Master 20-21 Net Sales Y5}, {Master 20-21 LAM Key}, CONTAINS([Main Product Type]@row, {Master 20-21 LAM Key}))

Where

{Master 20-21 LAM Key} is the MultiDropdown containing the various products in transaction sheet

[Main Product Type]@row is the product (in my product sheet) I'm seeking for in the Multi-Dropdown (in the transaction sheet.

but it returns 0.

Anyone can help, I'm pretty stuck there.

raoul.tserstevens26401

Well, sometimes working hard helps.

I just made it more complicated than needed.

=SUMIFS({Master 20-21 Net Sales Y5}, { Master 20-21 LAM Key}, has(@cell, [Main Product Type]@row))

Hope this helps someone :)

All the best

Raoul.

raoul.tserstevens26401

Well, sometimes working hard helps.

I just made it more complicated than needed.

=SUMIFS({Master 20-21 Net Sales Y5}, { Master 20-21 LAM Key}, has(@cell, [Main Product Type]@row))

Hope this helps someone :)

All the best

Raoul.

Genevieve P.

Hi Raoul,

Thank you for sharing your solution!

raoul.tserstevens26401

You most welcome.