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

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.

Find more posts tagged with

Accepted answers

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.

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.