Multiple sumifs

JANET WEEKS · 03/01/21

=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.

Bassam Khalil · 03/01/21

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 · 03/01/21

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 · 03/01/21

@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.