=SUM(IF(($D$2:$D$150="sheet2!A3")*$B$2:$B$150<" 3/2/2009"),$J$2:$J$150))

Try this normally entered formula.

Use a cell to hold your date criteria:

A1 = 3/2/2009

=SUMPRODUCT(--(D2:D150=Sheet2!A3),--(B2:B150<A1),J2:J150)

Problem #2 = Where do we lookk for the hours worked?

--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
Problem #1
I am also trying to find out the number of LATE hours by work center. So
if
the work center has some hours logged in but there less than a given date
i
want to see them. The formula I'm trying to use is.
=SUM(IF(($D$2:$D$150="sheet2!A3")*$B$2:$B$150<"3/2/2009"),$J$2:$J$150)).
This formula does not give me the correct results. column B has the dates,
column D has the work centers and column J has the
hours.
Problem #2
I have entered the dates excluding weekends at the top of each column. I
have the work centers listed in the rows going down the page. I want to be
able to see the number of hours by work center by date.

using excel 2003
--
SRC