Paddy1979
Well-known Member
- Joined
- Sep 23, 2005
- Messages
- 608
Hello please can you help me finish my formular.
I'm trying to count how many dates in sheet Jobs column O are in the past, depening on sheet 1 B2 matches entries in Jobs colmn N.
=SUMPRODUCT(--(JOBS!$N$1:$N$4819=Sheet1!$B2),--(JOBS!$O$1:$O$4819 ???? ))
thanks for looking,
I'm trying to count how many dates in sheet Jobs column O are in the past, depening on sheet 1 B2 matches entries in Jobs colmn N.
=SUMPRODUCT(--(JOBS!$N$1:$N$4819=Sheet1!$B2),--(JOBS!$O$1:$O$4819 ???? ))
thanks for looking,