Sumproducts with return of text

[Solazie]

Hello,

I've been using this formula:

=SUMPRODUCT(SUMIF(INDIRECT("'"&Buyplan&"'!$A$1:$A$10600"),$A7,INDIRECT("'"&Buyplan&"'!F$1:F$10600")))

and notice that doesn't return any text, I still need to get the summation across different sheet, but there are instances it has a text, text contains "On-Hand"

Please help,

Thanks,

 

[Joe4]

SUMPRODUCT can only return numbers (or errors).
You would need to use other functions to return text, like VLOOKUP or INDEX/MATCH.
See: https://www.mrexcel.com/forum/excel-questions/559170-can-sumproduct-modified-return-text.html