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...