Sumproduct returns 0

[Hawkeyed]

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.

 

[pecoflyer]

Cross post https://www.mrexcel.com/board/threads/sumproduct-returns-0.1157407/

 

[vletm]

Hawkeyed
You should reread Forum Rules:

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

Those are for everybody as well as for You too.

 

[Fluff13]

Also

Sumproduct returns 0 - OzGrid Free Excel/VBA Help Forum

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 questionHi all,I'm running into an issue with the SUMPRODUCT formula returning 0 instead of…

www.ozgrid.com