Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
filter and count | Excel Discussion (Misc queries) | |||
Count occurences between dates | Excel Worksheet Functions | |||
Count If Formula | Excel Worksheet Functions | |||
How can I use count function in excel where I have several criter. | Excel Worksheet Functions | |||
count based on two fields - need quickly | Excel Worksheet Functions |