Hi all,
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 returns 0's instead.
I'm running into an issue with the SUMPRODUCT formula returning 0 instead of the actual values.
VBA Code:
=SUMPRODUCT(SUMIF(INDIRECT("'"&listsheets&"'!C2:C358");$A$2;INDIRECT("'"&listsheets&"'!D2:D358")))
"'"&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 returns 0's instead.