sumproduct help

[Paddy1979]

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,

 

[Oaktree]

=SUMPRODUCT(--(JOBS!$N$1:$N$4819=Sheet1!$B2),--(JOBS!$O$1:$O$4819<TODAY()))

Assuming O1:O4819 are Excel dates.

 

[Dufus]

maybe <"now"() without the double quotes.

 

[Paddy1979]

yes sorry they are dates on colmn 0

 

[mtb'r]

Here is one possible solution:

=SUMPRODUCT(--(Jobs!$N$1:$N$4819=Sheet1!$B2)*--(Jobs!$O$1:$O$4819<TODAY()))

 

[Paddy1979]

Cheers mate, thats done the trick