COUNTIFS Formula not working when I add an ISBLANK statement

I have a COUNTIF formula that I can't get to work once I add an ISBLANK statement.

This is the fomula that works:

=COUNTIFS({Payment Type}, =$Status@row, {Case Date}, MONTH(@cell) = 8, {Case Date}, YEAR(@cell) = 2020, {Status}, ="Completed")

When I try to account for rows where the Payment Type is blank, I tried this formula:

=COUNTIFS({Payment Type}, ISBLANK(@cell), {Case Date}, MONTH(@cell) = 8, {Case Date}, YEAR(@cell) = 2020, {Status}, ="Completed")

However, I'm getting an #INVALID DATA TYPE error. What am I doing wrong?

Find more posts tagged with

Formulas

Accepted answers

L_123

month(@cell)=8

month day and year formulas pop an error when used on a blank cell. use this to replace your month(@cell)

iferror(month(@cell),0)=8

*you should also do this for your year formula

S_Karkhoff

Thank you, that worked!

All comments

L_123

month(@cell)=8

month day and year formulas pop an error when used on a blank cell. use this to replace your month(@cell)

iferror(month(@cell),0)=8

*you should also do this for your year formula

S_Karkhoff

Thank you, that worked!

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.