Paddy1979
Well-known Member
- Joined
- Sep 23, 2005
- Messages
- 608
Hi All, please can you help.
I have this formular to count the dates in sheet 'jobs' column 'I' that are in the past, but its not counting the figures correctly.
Is there somthing i am missing?
=SUMPRODUCT(--(JOBS!$N$1:$N$4594=Sheet1!$B2),--(JOBS!$I$1:$I$4594 < TODAY()))
Thanks
Paddy
I have this formular to count the dates in sheet 'jobs' column 'I' that are in the past, but its not counting the figures correctly.
Is there somthing i am missing?
=SUMPRODUCT(--(JOBS!$N$1:$N$4594=Sheet1!$B2),--(JOBS!$I$1:$I$4594 < TODAY()))
Thanks
Paddy