I have the following formula using SUMIFS, it works beautiful until I drag it accross. No matter many different variations I place in the formula I cannot seem to get it to stick on the Part Numbers column.
=SUMIFS('Sales Dates'!$B:$B,'Sales Dates'!$A:$A,Table1[[#This Row],[Part Numbers]],'Sales Dates'!$D:$D,Table1[[#Headers],[2/23/09]])
Any help you can give is greatly appreciated!!!
Thanks
Bookmarks