Thread: Trying to get a result from 2 variables
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TomPl TomPl is offline
external usenet poster
  
Posts: 342
Default Trying to get a result from 2 variables
Just another sum product. Try this, but remember that the three ranges
specified in the formula must be the same size:

=SUMPRODUCT(--('UC COMPLETO'!A4:A3553=D16),--('UC
COMPLETO'!D4:D3553=C16),('UC COMPLETO'!G4:G3553))

Tom
Reply With QuoteReply With Quote