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

Options

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.

Best Answer

  • raoul.tserstevens26401
    Answer ✓
    Options

    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.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!