It's difficult to see what's going on without the actual cell references.

Nevertheless, make sure that your named ranges Weave_Data_MTD and
Weave_Date_MTD reference the same range of columns.

If you still have problems, re-post the formula with the actual cell
references.

In article ,
"CheeseHeadTransplant"
wrote:

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.