Formula to count volume based on month
Hello,
I have a column that captures the month each time a form is submitted. I would like to create a summary formula that allows me to track the volume received each month.
Any help would be appreciated!
Also, will the single formula be able to track the volume for each month separately or will I need to create a new summary field/formula for each individual month? (i.e. Summary field 1 with formula for January, field 2 for Feb, etc)
Best Answer

If you want to be able to view each month's counts separately then you will need separate fields, but if you just want current month then you would only need one formula.
=COUNTIFS([Submission Date]:[Submission Date], AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2023))
The above will give you January 2023. TO change it to current month/year, you would replace the month and year numbers with MONTH(TODAY()) and YEAR(TODAY()).
Answers

If you want to be able to view each month's counts separately then you will need separate fields, but if you just want current month then you would only need one formula.
=COUNTIFS([Submission Date]:[Submission Date], AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2023))
The above will give you January 2023. TO change it to current month/year, you would replace the month and year numbers with MONTH(TODAY()) and YEAR(TODAY()).

That worked. Thank you!

Happy to help. 👍️
Help Article Resources
Categories
Check out the Formula Handbook template!