View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
 
Posts: 1,240
Default 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.