Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Values
I am still having an issue with counting values: I want to count the number of values in multiple cells that meet a condition. Two of the conditions a Greater than 6 but less than 10 Greater than 11 but less than 15 The countif function only lets me calculate one time correctly. When the countif function is used twice in the same cell, subtracting the two answers, it gives me an answer that is one more than it should be. An example of the function I have tried from another post is this: =(COUNTIF(B2:B28,"=6")-COUNTIF(B2:B28,""<=10)) -- Barb |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Values
Hi
You can use countif array function: =COUNT(IF((B2:B28=6)*(B2:B28<10),B2:B28))+COUNT(I F((C2:C28=11)*(C2:C28<15),C2:C28)) OR =COUNT(IF((B2:B28=6)*(B2:B28<10),B2:B28))+COUNT(I F((C2:C28=11)*(C2:C28<15),C2:C28)) Once you entered function, press "Ctrl+Shift+Enter" With regards Rafeek M "Barb Miles" wrote: I am still having an issue with counting values: I want to count the number of values in multiple cells that meet a condition. Two of the conditions a Greater than 6 but less than 10 Greater than 11 but less than 15 The countif function only lets me calculate one time correctly. When the countif function is used twice in the same cell, subtracting the two answers, it gives me an answer that is one more than it should be. An example of the function I have tried from another post is this: =(COUNTIF(B2:B28,"=6")-COUNTIF(B2:B28,""<=10)) -- Barb |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Values
=SUMPRODUCT((B2:B286)*(B2:B28<10)*(B2:B28))+SUMPR ODUCT((B2:B2811)*(B2:B28<15)*(B2:B28))
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Values
Hi!
Try these: Greater than 6 but less than 10 =COUNTIF(B2:B28,"6")-COUNTIF(B2:B28,"=10") Greater than 11 but less than 15 =COUNTIF(B2:B28,"11")-COUNTIF(B2:B28,"=15") Biff "Barb Miles" wrote in message ... I am still having an issue with counting values: I want to count the number of values in multiple cells that meet a condition. Two of the conditions a Greater than 6 but less than 10 Greater than 11 but less than 15 The countif function only lets me calculate one time correctly. When the countif function is used twice in the same cell, subtracting the two answers, it gives me an answer that is one more than it should be. An example of the function I have tried from another post is this: =(COUNTIF(B2:B28,"=6")-COUNTIF(B2:B28,""<=10)) -- Barb |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting unique values with criteria | Excel Worksheet Functions | |||
Counting Values on a condition | Excel Worksheet Functions | |||
If Then, not using values, or not counting blanks | Excel Worksheet Functions | |||
Counting Values | Excel Discussion (Misc queries) | |||
Counting values | Excel Worksheet Functions |