Posted to microsoft.public.excel.worksheet.functions
|
|
Two Matches, then Sumproduct of Values
Here is a sample:
http://rs173.rapidshare.com/files/196921830/sample.xls
I was trying to get Cell M2 to be 4500.
Thanks,
Ryan--
--
RyGuy
"T. Valko" wrote:
Can you post a *small* data sample that shows us what you want?
--
Biff
Microsoft Excel MVP
"ryguy7272" wrote in message
...
Thanks Biff! That's pretty close, but it's not doing what I really want
it
to do. If I have $1,200 in Cell V2 and $1,800 in Cell V3, and a name,
Dave
in Cell C3, I see $1,800. If I move Dave to Cell C2, I see $1,200. I
wanted
Dave in any Cell in Column C, (down to row 678) and I would see $3,000. I
committed with CSE; still didn't give me the results I was seeking.
Any thoughts?
Thanks,
Ryan---
--
RyGuy
"T. Valko" wrote:
Maybe this:
=SUMPRODUCT(--(Sheet2!$A$2:$A$678=Sheet1!$E$2:$E$678),--(Sheet1!$C$2:$C$678=C64),Sheet1!$V$2:$V$678)
--
Biff
Microsoft Excel MVP
"ryguy7272" wrote in message
...
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! I'm
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
|