Thread: Case Sensitive SumProduct
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ben McClave Ben McClave is offline
external usenet poster
  
Posts: 173
Default Case Sensitive SumProduct
Hi,

You could try the EXACT formula:

EXACT($J$48:$J$22962,$W19)

in place of

($J$48:$J$22962=$W19)
Reply With QuoteReply With Quote