Using SumIf Across Multiple Worksheets - Excel 2003

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top