Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Greater than Less than formula
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Greater than Less than formula
In B32 put =COUNTIF(B6:B31,"<100")-COUNTIF(B6:B31,"<=50")
In B33 put =COUNTIF(B6:B31,"<49")-COUNTIF(B6:B31,"<=40") In B34 put =COUNTIF(B6:B31,"<39")-COUNTIF(B6:B31,"<=30") Vaya con Dios, Chuck, CABGx3 "Help with Check Mark!!" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Greater than Less than formula
Try these:
=SUMPRODUCT(--($B$6:$B$31<100),--($B$6:$B$3150)) =SUMPRODUCT(--($B$6:$B$31<49),--($B$6:$B$3140)) =SUMPRODUCT(--($B$6:$B$31<39),--($B$6:$B$3130)) "Help with Check Mark!!" wrote: 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Greater than Less than formula
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 | |
|
|
Similar Threads | ||||
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 |