Count if data falls within a range AND that has a certain criteria

L

LaVitaEBella

Dear all,

Grateful for your advice on how to proceed with counting the no. o
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. o
'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 Ye
 
C

Claus Busch

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
Click to expand...

try:
=SUMPRODUCT(--(A1:A100>0),--(A1:A100<=10),--(B1:B100="Yes"))


Regards
Claus Busch
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show value from one cell in another cell if today falls between a date range 5
Cell reference being changed to a specific criteria in IF formula...HELP! 0
Formula to count data in a column that falls between a range 3
Excel - count if a number falls within an array in a column & add 2
SUMIF data that falls within a range 3
referencing a range in Sumproduct function 6
identify which years are contained within a range of dates 2
Lookup value that falls between two values in a range and then som 2

Top