COUNTIF:CONTAINS formula help

Hello!

I'm working on a formula to capture project start dates in each month. The formula I'm using is as follows: =COUNTIFS({Target Start Date}, (CONTAINS("January", @cell)), {Status}, ="In Progress", {Type}, ="Enterprise") I'm not getting an error message with this formula but it doesn't appear to be capturing any of the projects with a January start.

Any help would be appreciated. Thanks!

Find more posts tagged with

Accepted answers

All comments

Paul McGuinness

Hello @anuelle

This formula should work for you, made assumption on the column names.

=COUNTIFS(Status:Status, "In Progress", Type:Type, "Enterprise", [Target Start Date]:[Target Start Date], MONTH(@cell) = 1)

Hope that helps.

Paul

anuelle

This doesn't appear to be working either. I don't know if it makes a difference or not, but the columns I'm referencing are on a separate sheet. Would that cause the error I'm having?

Genevieve P.

Hi @anuelle

Yes, it will make a difference if you're looking into another sheet! You'll need to update each of Paul's [in-sheet ranges] with your own {Cross sheet ranges}, like so:

=COUNTIFS({Status}, "In Progress", {Type}, "Enterprise", {Target Start Date}, MONTH(@cell) = 1)

Sometimes you can get an error if the Start Date has text or blank cells, so you can wrap your MONTH portion in an IFERROR to get rid of that:

=COUNTIFS({Status}, "In Progress", {Type}, "Enterprise", {Target Start Date}, IFERROR(MONTH(@cell), 0) = 1)

If this still hasn't worked, it would be helpful to know exactly what formula you've tried and what error message you're getting.

Thanks!

Genevieve

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.