need help using count if
 

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

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

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Lionheartilly" schrieb im
Newsbeitrag ...

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