Counting data between 2 values
Hi,
I have a list of durations on 1 cell (as below).
1
21
54
72
95
170
etc....
I want to count how many of them are between 0 and 60, how many between 61
and 120, so on and so forth. I have tried using Countif, but can't get it to
work. My last attempt was =count(if(and('Site
list_South'!$E$2:$E$5000=0,'Site list_South'!$E$2:$E$5000<=60)) and it
failed miserably.
Please Help!!!!
|