How to calculate number of request per month and status?

iamje
✭✭
Hi,
Data are:
Requested date formatted as 12/01/21 and Status such as New, In-Progress and Complete. Now I would like to calculate how may request do I have per month and the corresponding status. So basically considering only open requests.
thank you in advance for your help.
Answers
-
Assuming that by "open" you mean not "Complete", try this...
=COUNTIFS([Date Column]:[Date Column], AND(IFERROR(MONTH(@cell), 0) = 12, IFERROR(YEAR(@cell), 0) = 2021), Status:Status, @cell <> "Complete")
You would just need to change the bold numbers to match whichever year and month you are wanting to count for.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives