countif

[Khalil Handal]

13 values are in range DI15U15
I need to count the values in each cell in the range if it is less than the
corresponding number in the range DI14U14.

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

 

[Ron Rosenfeld]

13 values are in range DI15U15
I need to count the values in each cell in the range if it is less than the
corresponding number in the range DI14U14.

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

=SUMPRODUCT(--(DI15U15<DI14U14))

--ron

 

[T. Valko]

Try this...

Assuming there are no empty cells:

=SUMPRODUCT(--(DI15U15<DI14U14))

 

[Ron Rosenfeld]

Try this...

Assuming there are no empty cells:

=SUMPRODUCT(--(DI15U15<DI14U14))

Empty cell problem? What did I miss?
--ron

 

[T. Valko]

If DI14 = 100 and DI15 = empty cell this will be counted. Should it be
counted?

 

[Khalil Handal]

Thanks to both

Empty cell problem? What did I miss?
--ron

 

[Ron Rosenfeld]

If DI14 = 100 and DI15 = empty cell this will be counted. Should it be
counted?

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

 

[Ron Rosenfeld]

Thanks to both

You're welcome. Glad to help.
--ron