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

--
Don Guillett
SalesAid Software

"Lionheartilly" wrote in
message ...

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 contain
0-30, 30-60, 60-90 that represents the different months.

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

Thanks

Lion


--
Lionheartilly
------------------------------------------------------------------------
Lionheartilly's Profile:
http://www.excelforum.com/member.php...o&userid=16537
View this thread: http://www.excelforum.com/showthread...hreadid=313865