Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
enter
10 20 30 40 50 100 in C6:C11 Select D6:D11, and ctrl/shift/enter: =FREQUENCY(B6:B31,C6:C11) "Help with Check Mark!!" wrote in message ... I have data in cells B6 through B31. In B32 I need to know the count of B6:B31 that are greater than 50 but less than 100. In B33 I need to know the count of B6:B31 that are greater than 40 but less than 49. In B34 I need to know the count of B6:B31 that are greater than 30 but less than 39. etc. How? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
writing a greater than/less than formula | Excel Worksheet Functions | |||
formula to workout equal to or greater than | Excel Worksheet Functions | |||
Greater than formula! | Excel Worksheet Functions | |||
Formula which is greater tahn or equal to zero | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |