COUNTIF when counting a range such as 1-5

Rebecca N

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

Darren Mullen

@Rebecca N What have you tried?

Rebecca N

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)

Nick Korna

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.

Rebecca N

Thanks, however there was and extra ( in the formula you gave.

Should read as

=COUNTIFS({ReviewersReviewTime}, >5, {ReviewersReviewTime}, <=10)

Nick Korna

My apologies, but glad you've got it working now. 😊