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

  • heyjay
    heyjay ✭✭✭✭✭
    edited 05/15/24
    Options
    =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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!