Multiple sumifs

=SUMIF([Platform Site]@row, CONTAINS("eBay", @cell), Net@row - [PayPal Fee]@row)

=SUMIF([Platform Site]@row, CONTAINS("fsx", @cell), Net@row - [Platform Fee]@row)

These work independently but I need them to work together for a column formula. When I try to put them together, I keep Error messages. Help. I have to have this sheet done today and this is one thing is holding me up. I know it may be something simple and I am just not seeing it.

Find more posts tagged with

Formulas

Accepted answers

All comments

Bassam Khalil

Hi @JANET WEEKS

Hope you are fine, as i understand your sheet in below screenshot please try the following formula

=IF([Platform Site]@row = "eBay", SUMIF([Platform Site]@row, CONTAINS("eBay", @cell), Net@row - [Platform Fee]@row), SUMIF([Platform Site]@row, CONTAINS("fsx", @cell), Net@row - [Platform Fee]@row))

Antonio Figueroa

Would it be easier to use a nested if statement.

=if([Platform Site]@row="eBay", Net@row - [PayPal Fee]@row,if([Platform Site]@row="fsx", Net@row - [Platform Fee]@row)

and then you can add a value if false at the end Optional!

=if([Platform Site]@row="eBay", Net@row - [PayPal Fee]@row,if([Platform Site]@row="fsx", Net@row - [Platform Fee]@row,"")

JANET WEEKS

@Bassam.M Khalil

Your formula works but the column with the platform also has numbers. Example eBay - 12345 or FSX - 8964. That is why I was using the CONTAIN function but was not able to combine both to make them work.

Antonio Figueroa

Try this

@JANET WEEKS

=IF(CONTAINS("ebay"@cell), Net@row - [PayPal Fee]@row,if(CONTAINS("FSX",@cell), Net@row - [Platform Fee]@row)

Antonio Figueroa

sorry forgot the "," after ebay

=IF(CONTAINS("ebay",@cell), Net@row - [PayPal Fee]@row,if(CONTAINS("FSX",@cell), Net@row - [Platform Fee]@row)

JANET WEEKS

@Antonio Figueroa

That is returning an #UNPARSEABLE error.

Antonio Figueroa

Can you show a snip

Antonio Figueroa

it is working on my end

Antonio Figueroa

Here is the link to the sheet I made

https://app.smartsheet.com/b/publish?EQBCT=4f4544c89e22454b832787d9e7db5d32

Antonio Figueroa

Did This Help

@JANET WEEKS

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.