COUNTIFS for specific Months

Hi All,

I have tried to read previous answer to similar questions but still just don't get it…. (excel is so much easier in some ways..)

So far I have this formula:

=COUNTIFS ({Push-In Job requests Range 2}, "Extrusion", {Push-In Job requests Range 3}, "Yes")

But I want to break it into Months based in the Date received field:

Can anyone help please?

Smartsheet still doesn't do Wildcards I guess * Feb * like excel?

Thank you in advance.

Find more posts tagged with

Accepted answers

All comments

A.Turner

I am assuming your range: {Push-In Job requests Range 2} ="dept" column

try:

=COUNTIF({Push-In Job requests Range 2}, "Extrusion", {Push-In Job requests "date received" column}, <=DATE(2025, 02, 28), {Push-In Job requests "date received" column}, >=DATE(2025, 02, 1))

Not sure if it works with your date like that though - "feb", might need to change it to 03/02/25 for the formula to work. Or ensure that it is a 'date' column.

A.Turner

Or did you want to sum the qty required if it is "extrusion" for the month of feb?

Richard A

https://community.smartsheet.com/discussion/comment/471946#Comment_471946

I want a sum of job for say the Extrusion Dept, which were accepted (Yes), within each calendar month - so I understand I'll have to type manual dates in.

Thank you

A.Turner

I think it could be:

=SUMIFS([Qty Require]:[Qty Require], [Type]:[Type], "Extrusion", [Approved]:[Approved], "Yes", [Date]:[Date], AND(MONTH(@cell) = 2, YEAR(@cell) = 2025))

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.