COUNTIF when counting a range such as 1-5
Source Sheet Columns: Reviewer - Time (days) - Text is numbers
Report Sheet
Need Formula: I want to count how many fall into all the rangers below. I know it's a COUNTIF but cant figure it out.
1-5 Days
6-10 Days
11-15 Days
16-20 Days
21-25 Days
26-30 Days
More than 30 Days
Answers
-
@Rebecca N What have you tried?
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
I can get the 1 - 5 ranges and the 30 plus range. I am not sure how to do 2 criteria in a formula.
6-10 not sure how to do the formula, I tried and it didn't work
=COUNTIF({ReviewersReviewTime}, >5, OR({ReviewersReviewTime}, <=10))
1 - 5 I used
=COUNTIF({ReviewersReviewTime}, <=5)
More than a Month (30 days) I used
=COUNTIF({ReviewersReviewTime}, >30)
-
Hi @Rebecca N
For the ranges that are ranges and not single values you can use the COUNTIFS formula instead:
=COUNTIFS({ReviewersReviewTime}, >5, ({ReviewersReviewTime}, <=10)
This should find the 6-10 days range. For the others you would just adjust the numbers in the formula as required.
-
Thanks, however there was and extra ( in the formula you gave.
Should read as
=COUNTIFS({ReviewersReviewTime}, >5, {ReviewersReviewTime}, <=10)
-
My apologies, but glad you've got it working now. 😊
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives