• 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

    Hui...

  • 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

Hawkeyed

New Member
Hi all,

I'm running into an issue with the SUMPRODUCT formula returning 0 instead of the actual values.

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

vletm

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