| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count if data falls within a range AND that has a certain criteria
Hi,
Am Fri, 27 Apr 2012 03:33:26 +0000 schrieb LaVitaEBella: A B 1 Yes 2 No 3 Yes 14 Yes 16 Yes 18 Yes 19 Yes try: =SUMPRODUCT(--(A1:A1000),--(A1:A100<=10),--(B1:B100="Yes")) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| Reply |
| 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 | |||
Linear Mode
