Thread: Obi Wan Kenobi: You're My Only...HELP!!!!!!
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Ginetta Ginetta is offline
external usenet poster
  
Posts: 12
Default Obi Wan Kenobi: You're My Only...HELP!!!!!!
=SUMPRODUCT((Sheet1!A2:A9=Sheet1!A2)*(Sheet1!B2:B9 =Sheet1!B4),Sheet1!
C2:C9)

Matching cell values in a lookup rather than specifying a static
value eliminates some comparison errors.

This formula will give you the desired result.

Nick


Reply With QuoteReply With Quote