COUNT IF - 2 conditions
 

2 columns.
column 1 needs to be searched for a certain numerical value (a 6 digit code)
column 2 is a series of numbers and needs to be searched for a value greater
than 30

i.e. would want to to bring up how many examples of 666666 have a value of
greater than 30

COUNT IF - 2 conditions
 

Hi Darren

=SUMPRODUCT(--($A$2:$A$1000=666666),--($B$2:$B$100030))
Better to put the values required in separate cells, then there is no need
to change the formula when you look for other results

=SUMPRODUCT(--($A$2:$A$1000=D1),--($B$2:$B$1000E1))

--
Regards
Roger Govier

"Darrren" wrote in message
...
2 columns.
column 1 needs to be searched for a certain numerical value (a 6 digit
code)
column 2 is a series of numbers and needs to be searched for a value
greater
than 30

i.e. would want to to bring up how many examples of 666666 have a value of
greater than 30

COUNT IF - 2 conditions
 

Try

=SUMPRODUCT((A1:A20=666666)*(B1:B2030))

Mike

"Darrren" wrote:

2 columns.
column 1 needs to be searched for a certain numerical value (a 6 digit code)
column 2 is a series of numbers and needs to be searched for a value greater
than 30

i.e. would want to to bring up how many examples of 666666 have a value of
greater than 30

COUNT IF - 2 conditions
 

=SUMPRODUCT((A1:A100=666666)*(B1:B10050))

so data like:

666666 1
666666 1
666666 100
666666 100
555555 100
555555 1
555555 1
555555 1

yields a 2
--
Gary''s Student - gsnu200819


"Darrren" wrote:

2 columns.
column 1 needs to be searched for a certain numerical value (a 6 digit code)
column 2 is a series of numbers and needs to be searched for a value greater
than 30

i.e. would want to to bring up how many examples of 666666 have a value of
greater than 30

COUNT IF - 2 conditions
 

Thank you Roger and Mike. Very much appreciate your assistance

Darren

"Mike H" wrote:

Try

=SUMPRODUCT((A1:A20=666666)*(B1:B2030))

Mike

"Darrren" wrote:

2 columns.
column 1 needs to be searched for a certain numerical value (a 6 digit code)
column 2 is a series of numbers and needs to be searched for a value greater
than 30

i.e. would want to to bring up how many examples of 666666 have a value of
greater than 30