COUNTIFS reference other cell, count cells with BLANK value in a column, part of formula works

I want to count how many cells are blank after they meet the range 1 and range 2 criteria. The formula works without the last part which is count blank cells. When I add the last part to the formula, it gives me #UNPARSEABLE error. What am I doing wrong?

=COUNTIFS({Range1}, "xyz", {Range2}, "abcd", {Range3}, <>"")

=COUNTIFS({Range1}, "xyz", {Range2}, "abcd", {Range3}, ISBLANK@cell)

Thanks

Find more posts tagged with

Accepted answers

All comments

Leibel S

@Aparna Kathiresan

All you missed are the parentheses for the ISBLANK function:

=COUNTIFS({Range1}, "xyz", {Range2}, "abcd", {Range3}, ISBLANK(@cell))

Jeff Reisman

@Aparna Singh

Looks like you're missing a set of parentheses on the ISBLANK(@cell):

=COUNTIFS({Range1}, "xyz", {Range2}, "abcd", {Range3}, ISBLANK(@cell))

Aparna Singh

@Leibel Shuchat Thanks for a prompt response. I corrected the formula and it still doesn't work 🙁

Aparna Singh

@Jeff Reisman Thanks for your response. I corrected the formula and it still doesn't work 🙁

Jeff Reisman

@Aparna Singh

Can you provide a snapshot of the ranges and data you're working with? What are the column types your ranges are referencing?

Aparna Singh

The column types are simple drop down values.

Now the error is incorrect argument set

=COUNTIFS({Request Type}, "enterprise", {status}, "not started", {Range3},ISBLANK(@cell))

Leibel S

@Aparna Singh

Check you cross sheet references, are they all the same size?

Aparna Singh

@Leibel Shuchat not sure if I understood your question, what are you referring to when you say check if all are same size?

Jeff Reisman

@Aparna Singh The three ranges need to be the same size. So if you selected the entire column from the remote sheet for one range, you need to select the entire column for the other ranges, or if you've only selected a subset of rows, you need to select the same subset for the other ranges.

Aparna Singh

Got it, yes I selected the whole column for all three.

Jeff Reisman

@Aparna Singh Are there any cells showing errors in the column ranges you are trying to count?

If not, can you add a temporary column in the sheet that contains your ranges, and try the following in one of the rows:

=COUNTIFS([Request Type]:[Request Type], "Enterprise", [Status]:[Status], "Not Started", Priority:Priority, ISBLANK(@cell))

Use the above formula exactly as I typed it, and see what result you get.

Here's what I get on my test sheet:

Aparna Singh

This worked. Thanks for all your help

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.