SUMPRODUCT problem

[ddub25]

=C77/SUMPRODUCT(--($A$56:$A$67=A77),--(AND(B77="Alias",$C$56:$C$67>0),$F$56:$F$67)

I've been trying to get the formula above to do the following, but it's not working.

IF MATCH is found between ($A$56:$A$67=A77)
AND B77="Alias"
AND,
OR C77>0
OR $C$56:$C$67>0 [the corresponding row in $C$56:$C$67 is C57 as a MATCH with A77 was found in A57]

Calculate, C77/$F$56:$F$67 [the corresponding row in $F$56:$F$67 is F57 as a MATCH with A77 was found in A57]

IF NOT, return 0

Any ideas?

Dan

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/showthread.php?t=565985

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).