hi CMO,

you could use sumproduct as:

=sumproduct(--(a1:a100=1)*--(a1:a100<=60))

hope this helps
Regards from Brazil
Marcelo

"CMO" escreveu:

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!!!!