I have a working sum product
=(SUMPRODUCT((MONTH(date)=(MONTH($C$2)))*(YEAR(date)=(YEAR($C$2)))*(MovementType=$I$2)*(Paper=$B6),SQMa))
the problem is
[FONT="](Paper=$b6) b6 could contain more than one product code variation eg 12345 / 32511 / 45722
is there a way to make it look for the all of the options? [/FONT]
=(SUMPRODUCT((MONTH(date)=(MONTH($C$2)))*(YEAR(date)=(YEAR($C$2)))*(MovementType=$I$2)*(Paper=$B6),SQMa))
the problem is
[FONT="](Paper=$b6) b6 could contain more than one product code variation eg 12345 / 32511 / 45722
is there a way to make it look for the all of the options? [/FONT]