CountIFs Range in same colomn
I am trying to do a count of number of contract that will be expiring between 30 - 60 days
I tried these and various formulae but still nothing works:
=COUNTIFS([Days till Contract Expiry]:[Days till Contract Expiry], “>=”&30, [Days till Contract Expiry]:[Days till Contract Expiry], “<=”&60)
and
=COUNTIF([Days till Contract Expiry]:[Days till Contract Expiry], >30, <60)
Can someone assist?
Best Answer
-
Hi,
I presume you are entering this into a sheet summary field, you can try the below formula:
=COUNTIF([Days till Contract Expiry]:[Days till Contract Expiry], >29) - COUNTIF([Days till Contract Expiry]:[Days till Contract Expiry], >60)
Regards
J Tech
If my response has helped you in any way or provided a solution to your problem, please consider supporting the community by marking it as Insightful, Vote Up, or Awesome. Additionally, you can mark it as the accepted answer, which will make it easier for others to find a solution or get help with a similar issue in the future. Your support is greatly appreciated!
Answers
-
Hi,
I presume you are entering this into a sheet summary field, you can try the below formula:
=COUNTIF([Days till Contract Expiry]:[Days till Contract Expiry], >29) - COUNTIF([Days till Contract Expiry]:[Days till Contract Expiry], >60)
Regards
J Tech
If my response has helped you in any way or provided a solution to your problem, please consider supporting the community by marking it as Insightful, Vote Up, or Awesome. Additionally, you can mark it as the accepted answer, which will make it easier for others to find a solution or get help with a similar issue in the future. Your support is greatly appreciated!
-
Yes it is in the summary field. Thank you so much, that worked.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!