Count of units in a date range

Aaron Collins

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.

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.

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.