Hello All
B4 on the Plastics Tab - Current formula - SUM(IF(ISNUMBER(FIND("405PN/L",mfg!B1:B1190)),mfg!G1:G1190,0)) I need this to somhow look at a date range also, so, it reoprts on the fiffernet days,
Please Note: i cant use a pivot as its part of another spreadsheet
Please see attached to help understanding
Cheers
Bookmarks