S
Steve
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
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