Sumproduct again?
 

I have two ranges both of equal size; the first DU11:EL60 contains integers
ranging from 0 to about 60; the second range FE11:FV60 contains integers
ranging from 0 to about 25.
What I would like to do is count the number of values of 5 or less in the
first range when the corresponding cells in the second range is 0.
Sandy

Sumproduct again?
 

Hi,

Try this, adjust tou to your actual ranges

=SUMPRODUCT((DV11:EC11<=5)*(DV12:EC12=0))

Mike

"Sandy" wrote:

I have two ranges both of equal size; the first DU11:EL60 contains integers
ranging from 0 to about 60; the second range FE11:FV60 contains integers
ranging from 0 to about 25.
What I would like to do is count the number of values of 5 or less in the
first range when the corresponding cells in the second range is 0.
Sandy

Sumproduct again?
 

Perfect Mike - Thank you
Sandy

"Mike H" wrote in message
...
Hi,

Try this, adjust tou to your actual ranges

=SUMPRODUCT((DV11:EC11<=5)*(DV12:EC12=0))

Mike

"Sandy" wrote:

I have two ranges both of equal size; the first DU11:EL60 contains
integers
ranging from 0 to about 60; the second range FE11:FV60 contains integers
ranging from 0 to about 25.
What I would like to do is count the number of values of 5 or less in the
first range when the corresponding cells in the second range is 0.
Sandy