Formula for CountIf One column has a value and another column is not blank

Hello,

I'm reaching out to the community for help with creating two separate sheet summary formulas (see example in image below), to:

Count the "red" values in the "ryg" column ONLY IF the "New Target Finish" column value is NOT blank
Count the number of blank cells in the "New Target Finish" column

Thank you, in advance, for helping me with these formulas. The "blank" values + multiple COUNTIF conditions are stumping me and I keep getting #unparseable errors so far.

--Lisa M

Find more posts tagged with

Accepted answers

Kelly Moore

Hey @Lisa Matthews

Try this

=COUNTIFS(ryg:ryg, "Red", [New Target Finish]:[New Target Finish], @cell<>"")

=COUNTIFS([New Target Finish]:[New Target Finish], @cell = "", [Task Name]:[Task Name], @cell <> "")

For your empty Target Finish count I added your primary column to the formula as a filter - otherwise the formula would find the empty cells all the way down the sheet regardless if you were using the row or not.

Do these work for you?

Kelly

All comments

Kelly Moore

Hey @Lisa Matthews

Try this

=COUNTIFS(ryg:ryg, "Red", [New Target Finish]:[New Target Finish], @cell<>"")

=COUNTIFS([New Target Finish]:[New Target Finish], @cell = "", [Task Name]:[Task Name], @cell <> "")

Do these work for you?

Kelly

Lisa Matthews

Hello @Kelly Moore

These formulas are exactly what I need! I just copied and pasted them directly into the sheet summary field and they work perfectly! Thank you for adding in the condition for the Task Name, it is the right solution. I appreciate your help so much!

--Lisa

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.