COUNTIFS Column A is blank and Column B does not contain 1
Options
Hi All,
I am struggling to make the COUNTIFS formula work in a Sheet Summary Field where Column A is blank and Column B does not contain 1. NOTE: Column B is a formula column with the following  =COUNT(ANCESTORS([Risk Number]@row)).
=COUNTIFS([Column A]:[Column A], "", [Column B]:[Column B], NOT(CONTAINS("1", @cell)))
Additionally, what would the formula be if I'm looking to count rows where Column A is blank and Column B contains "2" or "3"?
Any assistance would be appreciated!
Tags:
Answers

=COUNTIFS( [Column A]:[Column A], "", [Column B]:[Column B], FIND( [Column B]:[Column B], 1) = 0 )
I used
FIND
function to look for cells that is not equal to 1.
Replace 1 with your new query (2 or 3)....
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!