COUNTIFS Column A is blank and Column B does not contain 1

ctran

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!

heyjay

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