I would use
=sumproduct(--(A1:A10<=15))
=sumproduct(--(A1:A1015),--(A1:A10<=30))
=sumproduct(--(A1:A1030),--(A1:A10<=60))
=sumproduct(--(A1:A1060))
"Roy" wrote:

Hi,

I need to count days that an item is open e.g. 0-15 days, 16-30, 31-60,61+.
I can get the 0-15 and 61+ using this formula

=SUMPRODUCT(--(COUNTIF(A2:A10,"<15"))

How can I count the items that are open 16-30 and 31-60 days.