Countifs formula not returning a value.

Challenge: Countifs formula is not returning a value from a cross sheet. Any help would be so greatly appreciated.

Summary: I am trying to pull in counts for a specific month and status for an application. The formula doesn't state any errors but it doesn't return the values.

Formula: =COUNTIFS($Name18, {Status}, [JAN 25]17, {Mapped Month and Year})

Sheet 1 - Metrics Sheet with Status and dates across the top - column is text/Number.

Sheet 2 - App Schedule column is in a date format, if I change it to Text then the breakout formula doesnt work. The intent of breaking out the numbers is to get to a month and year for an App Exit. Exp if an App has any date in January it would roll up to Jan 1 2025.

Find more posts tagged with

Countif

Accepted answers

Paul Newcome

Your syntax is backwards.

You have:

criteria, range, criteria, range

You should have:

range, criteria, range, criteria

All comments

Paul Newcome

Your syntax is backwards.

You have:

criteria, range, criteria, range

You should have:

range, criteria, range, criteria

Wyckstandt

Hi Paul,

Thank you so much Paul. I did change the Syntax, rooky mistake.

Could their be any other issue? It is still not returning a count.

Thank you!!

Wyckstandt

I was able to reformat my date on sheet 2 and now the formula works.

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.