NEW! COUNTIF not blank....

I want to count how many columns have a date in the "SMD/IME Appointment Date" row and where the "Case Closure Date" cell in that column is blank:

=COUNTIF(AND(NOT(ISBLANK([SMD / IME Appointment Date]))), ISBLANK([Case Closure Date], ))

Attempt #2:

=COUNTIF(AND(NOT(ISBLANK([SMD / IME Appointment Date]))), ISBLANK([Case Closure Date], true ))

Attempt #3:

=COUNTIF(AND([SMD / IME Appointment Date]), [Case Closure Date], "")

Attempt #4:

=COUNTIF(AND([SMD / IME Appointment Date]), [Case Closure Date], <> "")

Attempt #5

=COUNTIF(AND([SMD / IME Appointment Date]:[SMD / IME Appointment Date]), [Case Closure Date], "")

Formulas Came Back #UNPARSEABLE

These next two came back #INCORRECT ARGUMENT SET......

=COUNTIF(AND([SMD / IME Appointment Date]:[Case Closure Date], ""))

=COUNTIF(AND([SMD / IME Appointment Date]:[SMD / IME Appointment Date]), [Case Closure Date]:[Case Closure Date], "")

Find more posts tagged with

Formulas

Support

Solution Center

functionality

Sheet Summary

Accepted answers

All comments

Mary Royston

Hey @Briana

I am not sure if I am understanding this correctly but... the SMD/IME Appointment Date is a column, and the Case Closure Date is a columns and you want a count of where the SMD/IME is not blank, but the Case Closure Date is blank? If so, you can use a Countifs formula like so:

=COUNTIFS([SMD/IME Appointment Date]:[SMD/IME Appointment], NOT(ISBLANK(@cell)), [Case Closure Date]:[Case Closure Date], ISBLANK(@cell))

This formula will count all the cells with a SMD/IME Date, that have a blank Case Closure Date.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.