Hi Cindy

Suppose you have the Sheets named Jan,Feb,Mar,Apr and you are currently
working on Apr. I assume you insert two columns every day for Pounds and
Hours just before the WeektoDate column/ If my assumption is correct you can
try the below

I assume we have 5 days represented from Col A to Col K. For the pound total
in the current sheet use the below formula in cell L3.
=SUMPRODUCT(--($A2:K2="Pounds"),--($A3:K3))

In M3 where you need to get the details from the previous sheet ie(Mar) use
the below formula
=SUMPRODUCT(--(Mar!$A2:K2="Pounds"),--(Mar!$A3:K3))

For having this formula rolling; leave 1 column blank and always insert a
column from col J.

If this post helps click Yes
---------------
Jacob Skaria


"Cindy" wrote:

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.