I'm running into an issue with the SUMPRODUCT formula returning 0 instead of the actual values.
"'"&listsheets&"'!C2:C358" - here is where I am looking for an item code
$A$2 - here is the input of the item code
"'"&listsheets&"'!D2:D358" - here is where the quantity (value) of the item should be returned
It worked with the first few worksheets but when I add more (and there is a lot of them) formula starts to return 0's instead.