Add another column to formula with exception
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.
Best Answer
-
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.
Answers
-
Try adding this in...
=COUNTIFS(..............................., CONTAINS("WON", @cell)), [XL Submittal Type]:[XL Submittal Type], @cell <> "Sole Sourced")
-
@Paul Newcome Thanks but that didnt work is removed all the Blank cells as well from the count
-
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 Thanks that one worked.
Thanks again
-
Happy to help. 👍️
Help Article Resources
Categories
Check out the Formula Handbook template!