Countif Formula not reporting Accurate number

Hello,

I'm trying to report a metric on a dashboard and am using the following formula:

=COUNTIF({Master Project Tracking Range 1}, ISBLANK(@cell) and the total is 29, however when I filter the grid the data is pulled from there are only 19 blank cells.

I've also tried =COUNTIF({Master Project Tracking Range 1}, "") and get 29. 🤔

Find more posts tagged with

Accepted answers

Paul Newcome

Because it is counting the 10 blank rows at the bottom of the sheet. Either subtracting 10 form the COUNTIF or switching to a COUNTIFS and including a range/criteria set for a column that is not blank should solve the problem.

All comments

Paul Newcome

Laura_SolAlt_5804

Got it! Thank you!

Paul Newcome

Happy to 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.