Formula to SUMPRODUCT & divide by SUM - Possible?

[lrusso]

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

 

[Macropod]

Hi lrusso,

That depends on what you're trying to achieve and what isn't working - so far you've posted a formula, with an indication that there's a problem with its results, but nothing much to go on as far as the rest is concerned.

Cheers