C
Charlie''s CA
I am trying to create a Summary Page for data contained on 8 other worksheets
in the same workbook. There are 8 categories or items which need to be
totaled by month. The data is contained in 8 daily production reports (1
report for each employee)
Production Report Sample:
Item being Tracked1
Date Qty Hours Avg Hr/item
10/01/09 5 2.5 .50
10/02/09 3 .75 .25
I would like the summary to look up the Qty for each month on, and total it.
I've been trying to include the date range in a SumIf, but cannot make it
work, even if I name the ranges.
Any suggestions? Is SumIF NOT the way to go?
in the same workbook. There are 8 categories or items which need to be
totaled by month. The data is contained in 8 daily production reports (1
report for each employee)
Production Report Sample:
Item being Tracked1
Date Qty Hours Avg Hr/item
10/01/09 5 2.5 .50
10/02/09 3 .75 .25
I would like the summary to look up the Qty for each month on, and total it.
I've been trying to include the date range in a SumIf, but cannot make it
work, even if I name the ranges.
Any suggestions? Is SumIF NOT the way to go?