• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sumproduct returns 0


New Member
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 return 0's instead.


Excel Ninja
You should reread Forum Rules:
Those are for everybody as well as for You too.