Thread: HELP with INDEX function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
  
Posts: 1,180
Default HELP with INDEX function
You can shorten your formula to
=SUMPRODUCT((TL=Sheet2!$A2)*(TM=Sheet2!$B2)*CRT1)
assuming column D = CRT1 = numbers
and TL, TM items are unique.

Reply With QuoteReply With Quote