Modify of SUM (IF(ISNUMBER(FIND( to loo at a dat also

[pmw19800]

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

[bebo021999]

Try with SUMIFS to sum column G with multi criterias in Date and Description

Please Login or Register  to view this content.

[pmw19800]

That works Great, would you mind telling me how it works ? as i could use for other things