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.
Answers
-
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))
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
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,"")
-
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.
-
Try this
=IF(CONTAINS("ebay"@cell), Net@row - [PayPal Fee]@row,if(CONTAINS("FSX",@cell), Net@row - [Platform Fee]@row)
-
sorry forgot the "," after ebay
=IF(CONTAINS("ebay",@cell), Net@row - [PayPal Fee]@row,if(CONTAINS("FSX",@cell), Net@row - [Platform Fee]@row)
-
That is returning an #UNPARSEABLE error.
-
Can you show a snip
-
it is working on my end
-
Here is the link to the sheet I made
https://app.smartsheet.com/b/publish?EQBCT=4f4544c89e22454b832787d9e7db5d32
-
Did This Help
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!