need help using count if

[Lionheartilly]

hi all,

thanks for taking the time to look!

I have a column with # ranging from 0-9999.
Now, I want to filter in to only obtain the # of rows that contai
0-30, 30-60, 60-90 that represents the different months.

I was able to get the first 30 using countif(F22:F3999, "<=30"), bu
then I don't know how to get the counts from 30-60.
Can anyone help me with this using a single formula?

Thanks

Lio

 

[Don Guillett]

try
=sumproduct((f22:f3999>=30)*(f22:f3999<60))

 

[Frank Kabel]

Hi
as alternative:
=COUNTIF(F22:F3999,">30")-COUNTIF(F22:F3999,">60")