Posted to microsoft.public.excel.worksheet.functions
|
|
Two Matches, then Sumproduct of Values
ryguy7272 wrote:
Here is a sample:
http://rs173.rapidshare.com/files/196921830/sample.xls
I was trying to get Cell M2 to be 4500.
Thanks,
Ryan--
You would need "Andy D Fox" in C2 and C3 to get that answer.
|