Thread: SUMPRODUCT WITH A VARIABLE CRITERIA?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cif Cif is offline
external usenet poster
  
Posts: 4
Default SUMPRODUCT WITH A VARIABLE CRITERIA?
HI, I WOULD DO SOMETHING LIKE THIS:

=SUMPRODUCT(--(A2:A500="x"),--(B2:B500=D1),C2:C500)

WHERE (CELL)D1 IS VARIABLE THAT I INTRODUCE

THANKS IN ADVANCE
Reply With QuoteReply With Quote