Help to count data
We have lot of tasks completed on different months on that how to calculate number of tasks completed on specific month for example on Month July 2023 with a condition that value shows Current=YES.
Best Answer
-
Try this:
=COUNTIFS(Current2:Current10, "Yes", Date2:Date10, AND(YEAR(@cell) = 2023, MONTH(@cell) = 7))
You will have to set your ranges to be applicable with your data but it should work otherwise.
Answers
-
Try this:
=COUNTIFS(Current2:Current10, "Yes", Date2:Date10, AND(YEAR(@cell) = 2023, MONTH(@cell) = 7))
You will have to set your ranges to be applicable with your data but it should work otherwise.
-
@SJM1609 Thanks! Is there any way to calculate it dynamically without specifying Year & Month on formula? means anyway to calculate by using current date on formula and calculating the values.
-
Hi @Hariharan ,
Try this:
=COUNTIFS(Current1:Current9, "Yes", Date1:Date9, IF(ISDATE(@cell), MONTH(@cell)) = MONTH(TODAY()))
Again, you will have to set your ranges to be applicable with your data but it should work otherwise.
Feedback is appreciated! :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!