Formulas

I am working on counting if criteria is met, but want to skip if the cell is blank. I have two formulas that work separately, but when I combine them I get an error.

CountIf

=COUNTIF([Connected to Confirmed]@row, "<7")

Skipping the blank cells

=IFERROR([Connected to Confirmed]@row, "")

I'm not sure what I'm doing incorrectly but I have the formulas counting based on a formula from another cell.

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Try something along the lines of...

=COUNTIFS([Column Name]:[Column Name], AND(@cell <> "", @cell < 7))

Deb Allen

That returns a value of 10...

Paul Newcome

You will want to double check the data within the column then. The formula specifies to count anything that is

Not Blank

AND

Less Than Seven

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.