Sorry... guess that would help....

=SUMIF(Weave_Market_MTD,A13,INDEX(Weave_Data_MTD,0 ,MATCH(Date,Weave_Date_MTD,0)))

whe

Weave_Market_MTD is on the sheet "Weave" and is column A

A13 is the item I need to sumif (C/R, EIFS, Scrim, OEM etc.)

Weave_Data_MTD is on the sheet "Weave" and is all the daily totals for each
market.

Date is the date the formula is to use to find the column to sum

Weave_Date_MTD is on the sheet "Weave" and is row 3 with a date and all data
entered for that day below it.

"Domenic" wrote:

Can you post the exact formula you're using?

In article ,
"CheeseHeadTransplant"
wrote:

This seems to be working except for one small problem... it is giving the
results for the wrong day. It is always off 3 days. If I query 09/01/05 it
is giving the results for 09/04/05. I can't figure out why the strange
result.