sumproduct help

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,
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,984
=SUMPRODUCT(--(JOBS!$N$1:$N$4819=Sheet1!$B2),--(JOBS!$O$1:$O$4819<TODAY()))

Assuming O1:O4819 are Excel dates.
 

mtb'r

New Member
Joined
Sep 8, 2006
Messages
42
Here is one possible solution:

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

Watch MrExcel Video

Forum statistics

Threads
1,113,849
Messages
5,544,647
Members
410,627
Latest member
georgealice
Top