Add another column to formula with exception

Shannon Lacerda

I am having trouble with a formula, I need to add to the current formula that I want to remove any any lines that have "Sole Sourced" in the XL Submittal Type Column.

Paul Newcome

That's odd that it would remove the blank cells from the count since blanks are not equal to "Sole Sourced". Let's try this to include them back in...

=COUNTIFS(..............................., CONTAINS("WON", @cell)), [XL Submittal Type]:[XL Submittal Type], OR(@cell <> "Sole Sourced", @cell = ""))

This says to include those cells that are not equal to "Sole Sourced" or are blank.

Paul Newcome

Try adding this in...

=COUNTIFS(..............................., CONTAINS("WON", @cell)), [XL Submittal Type]:[XL Submittal Type], @cell <> "Sole Sourced")

Shannon Lacerda

@Paul Newcome Thanks but that didnt work is removed all the Blank cells as well from the count

Paul Newcome

That's odd that it would remove the blank cells from the count since blanks are not equal to "Sole Sourced". Let's try this to include them back in...

=COUNTIFS(..............................., CONTAINS("WON", @cell)), [XL Submittal Type]:[XL Submittal Type], OR(@cell <> "Sole Sourced", @cell = ""))

This says to include those cells that are not equal to "Sole Sourced" or are blank.

Shannon Lacerda

@Paul Newcome Thanks that one worked.

Thanks again

Paul Newcome

Happy to help. 👍️