COUNTIF when CONTAINS a date

I am trying to create 2 different formulas. One for if the column has a date (any date) entered, I want it to add up only the cells with dates. The other formula will be if that same column has any cells with the word "FIRM".

=COUNTIF([IRB SUBJECT REMOVAL DATE]13:[IRB SUBJECT REMOVAL DATE]103 = DATE)

=COUNTIF([IRB SUBJECT REMOVAL DATE]13:[IRB SUBJECT REMOVAL DATE]103 = "FIRM")

I am clearly doing something wrong, as the formulas are not working. Any help would be appreciated.

Best Answer

  • KPH
    KPH ✭✭✭✭✭✭
    edited 11/23/23 Answer ✓

    This formula will count the number of rows in the date type column IRB SUBJECT REMOVAL DATE where the value in that column is a date.

    =COUNTIFS([IRB SUBJECT REMOVAL DATE]:[IRB SUBJECT REMOVAL DATE], ISDATE(@cell))


    To count just rows 13 to 103 you can use this:

    =COUNTIFS([IRB SUBJECT REMOVAL DATE]13:[IRB SUBJECT REMOVAL DATE]103, ISDATE(@cell))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!