I need a formula to compare the pound production of the current month, by
workdays, with the previous month. I have turned sumif and countif every way
I can and still can't get it to give me right total pounds.

To complicate the problem, the spreadsheet has the days across the rows with
a column for hours next to each day and then a week to date total at the end
of each week.

I have Excel 2007.

Ex.
Monday 2/3 Tuesday 2/4 Wednesday 2/5 Thursday 2/6 Friday 2/7 WeektoDate
Pounds Hours Pounds Hours Pounds Hours Pounds Hours Pounds Hours Pounds

11111 6.5 22222 7.0 33333 7.0 44444 7.0 55555 6.5
166665

There is then a column with the Month to date total. I have added a column
after that and want it to show the matching workdays amounts. Meaning, if I
have only 13 days of production so far this month I want the total of the
first 13 days of production in the previous month. Both months are in the
same workbook.