COUNTIF when counting a range such as 15
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.
15 Days
610 Days
1115 Days
1620 Days
2125 Days
2630 Days
More than 30 Days
Answers

@Rebecca N What have you tried?
Darren Mullen, smartsheetguru.com
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.
610 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 610 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. 😊