Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Count if data falls within a range AND that has a certain criteria
Dear all,
Grateful for your advice on how to proceed with counting the no. of entries that fall within a number range AND has a certain criteria. Eg. How can I create a formula that allows me to find out the no. of 'Yes' (column B) for values in column A between say 0 and 10. I tried using the following formula but it doesn't seem to work. Appreciate any advice you have! Thanks =SUMPRODUCT(--(SUMPRODUCT(--(range,0),--range,<=10)),--(range="yes")) A B 1 Yes 2 No 3 Yes 14 Yes 16 Yes 18 Yes 19 Yes |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to count data in a column that falls between a range | Excel Worksheet Functions | |||
COUNT IF A VALUE FALLS WITHIN A RANGE IN A SINGLE CELL | Excel Discussion (Misc queries) | |||
how to count if the value falls between a date range | Excel Discussion (Misc queries) | |||
get a count of numbers whose value falls within a given range | Excel Worksheet Functions | |||
How do I count data in range A:A that is dependent upon criteria . | Excel Worksheet Functions |