Count of units in a date range

I am looking to see if someone can help me add the total number of deliverable's in a given month. I have product being delivered in April, May, June, July and so on but, I want to create a dashboard from my master sheet that will tell me how many deliverable's I have in each month.

I am trying to use a countifs formula but I am not getting the results I am looking for. I have a date column and have a screenshot here.

Find more posts tagged with

Accepted answers

Paul Newcome

Try something along the lines of

=COUNTIFS([Delivery Date]:[Delivery Date], AND(IFERROR(MONTH(@cell), 0) = ##, IFERROR(YEAR(@cell), 0) = ####))

Just change the bold portions to whatever month and year you are wanting to count.

Paul Newcome

Happy to help! 👍️

Please don't forget to mark the most appropriate response as "helpful". This will let others searching for a similar solution know that one may be found here.

All comments

Paul Newcome

Try something along the lines of

=COUNTIFS([Delivery Date]:[Delivery Date], AND(IFERROR(MONTH(@cell), 0) = ##, IFERROR(YEAR(@cell), 0) = ####))

Just change the bold portions to whatever month and year you are wanting to count.

Aaron Collins

Minor tweaks and I got it working. Thank you for pointing me in the right direction!

Paul Newcome

Happy to help! 👍️

Please don't forget to mark the most appropriate response as "helpful". This will let others searching for a similar solution know that one may be found here.

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.