If date is greater than other date count one?

[Rosszx10r]

Hi thanks in advance for your help, this is my problem:
i have:
Target closure date (GMT) in row M2 to M6
05/06/2013 09:43:07 AM
05/06/2013 02:26:24 PM
05/06/2013 03:40:13 PM
06/06/2013 12:05:11 PM
10/06/2013 09:02:40 AM
06/06/2013 02:00:17 PM

Actual closure date (GMT) in row U2 to U6
07/06/2013 10:00:00 AM
07/06/2013 01:30:00 PM
07/06/2013 02:30:00 PM
10/06/2013 11:30:00 AM
10/06/2013 01:00:00 PM
10/06/2013 01:30:00 PM


What i need is compare for example M2 date to U2 date and count one if its bellow but i need to do that for a whole row of them

Thanks

[Ace_XL]

Try

=SUMPRODUCT(--(M2:M6<U2:U6))

[Rosszx10r]

Works great thanks but could you explain what that means?

[Ace_XL]

This might help..A good read on SUMPRODUCT

http://www.xldynamic.com/source/xld.SUMPRODUCT.html