Check count by project type AND how many started that month

Hi,

I'm trying to run a formula that would count how many projects were completed in a specific month and the column named "Tier" had the value of "Tier 3" but I can't seem to adapt the below successfully to include both conditions i.e. number of tier 3s completed in Jan

=COUNTIF([Actual End Date]23:[Actual End Date]81, IFERROR(MONTH(@cell), 0) = 1)

=COUNTIF(Tier23:Tier81, CONTAINS("Tier 3", @cell))

Any ideas on what would work here would be greatly appreciated!

Find more posts tagged with

Formulas

Accepted answers

Nick Korna

Hi @amyk

This should work to count the completed projects in a month:

=COUNTIFS(Tier:Tier, "3", [Actual End Date]23:[Actual End Date]81, IFERROR(MONTH(@cell), 0) = 1)

If you want to include additional data rather than just rows 23-81, you can delete these numbers from the formula to do the whole column to use:

=COUNTIFS(Tier:Tier, "3", [Actual End Date]:[Actual End Date], IFERROR(MONTH(@cell), 0) = 1)

Hope this helps!

All comments

Nick Korna

Hi @amyk

This should work to count the completed projects in a month:

=COUNTIFS(Tier:Tier, "3", [Actual End Date]23:[Actual End Date]81, IFERROR(MONTH(@cell), 0) = 1)

If you want to include additional data rather than just rows 23-81, you can delete these numbers from the formula to do the whole column to use:

=COUNTIFS(Tier:Tier, "3", [Actual End Date]:[Actual End Date], IFERROR(MONTH(@cell), 0) = 1)

Hope this helps!

amyk

Nick, thank you so much! That worked perfectly, I should have asked 3 hours ago!

Thanks for also provided the general formula outside of my selected rows :) super helpful!

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.