Countif checking for status and date range

jasonp
✭✭✭✭
Trying to create a data page based off another sheet to create counts of tickets (sync wit JIRA) that were closed withing a month. I have a column in the main sheet for "story", one for status "done" and one for update/close date from jira "Jira Update". So I need a count if where these items are true, plus where the date is Jan or Feb or Mar etc etc. Tired many combinations with no success. Anyone have ideas?
Comments
-
base countifs
=COUNTIFS({D2B Continuous Improvement Issue Type}, ="Story", {D2B Continuous Improvement Status}, ="Done")
how do I add to check the column
D2B Continuous Improvement JIRA Update
or
D2B Continuous Improvement Close Month
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 508 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives