countif

  • Thread starter Thread starter Khalil Handal
  • Start date Start date
K

Khalil Handal

13 values are in range DI15:DU15
I need to count the values in each cell in the range if it is less than the
corresponding number in the range DI14:DU14.

Example:
If value in DU14 is 100, and value in DU15 is 99 then the cell DU15 is to be
counted.

I hope that this is clear !
Thanks
 
13 values are in range DI15:DU15
I need to count the values in each cell in the range if it is less than the
corresponding number in the range DI14:DU14.

Example:
If value in DU14 is 100, and value in DU15 is 99 then the cell DU15 is to be
counted.

I hope that this is clear !
Thanks
Click to expand...

=SUMPRODUCT(--(DI15:DU15<DI14:DU14))

--ron
 
If DI14 = 100 and DI15 = empty cell this will be counted. Should it be
counted?
Click to expand...

I guess that hinges on the answer to the question "Is a blank cell less than
100?" I thought it probably is, but the OP may have a different answer.
--ron
 
Back
Top