Hi guys, here is what I have.
=SUMPRODUCT(('[Music Master Project sheet copy (2).xls]Sheet1'!$AP$2:$AP$65535>=1)*('[Music Master Project sheet copy (2).xls]Sheet1'!$H$2:$H$65535="Garbage"),'[Music Master Project sheet copy (2).xls]Sheet1'!$AP$2:$AP$65535))/SUM('[Music Master Project sheet copy (2).xls]Sheet1'!$AR$2:$AR$65535)))
I "think" the divisor is my problem. Any idea what I might be doing wrong? ALL suggestions welcome.
Thanks
=SUMPRODUCT(('[Music Master Project sheet copy (2).xls]Sheet1'!$AP$2:$AP$65535>=1)*('[Music Master Project sheet copy (2).xls]Sheet1'!$H$2:$H$65535="Garbage"),'[Music Master Project sheet copy (2).xls]Sheet1'!$AP$2:$AP$65535))/SUM('[Music Master Project sheet copy (2).xls]Sheet1'!$AR$2:$AR$65535)))
I "think" the divisor is my problem. Any idea what I might be doing wrong? ALL suggestions welcome.
Thanks