MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question
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.