Am trying to come up with a way to match names in Column A of Sheet2 with
names in Column E of Sheet1. If there is a match there, then match names in
Column C of Sheet2 with names in Column C of Sheet3, and sum the values, in
Column V of Sheet1, that match this name! Damn, this is tough! Im working
with this:
=SUMPRODUCT(--(Sheet2!$A$2:$A$678=Sheet1!$E$2:$E$678),SUMPRODUCT (Sheet1!$C$2:$C$678=C64),Sheet1!$V$2:$V$678)

I keep getting a #VALUE! result.

Sumproduct can be used up to 30 times in a single function, right. What am
I doing wrong?

Thanks,
Ryan---

--
RyGuy