Dear Friends,
I am trying to track monthly sales orders, executions and returns with percentages. I am trying to apply the following formula but getting #ref error. I've attached the file, please review and point out what is wrong with this function. Thanks in advance.
=SUMPRODUCT(SUMIF(INDIRECT("'"&$H$5:$H$16&"'!B5:B29"),$B5,INDIRECT("'"&$H$5:$H$16&"'!C5:29")))
Bookmarks