Thread: Using "--" as an array formula shortcut / alternative
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ollie4 Ollie4 is offline
external usenet poster
  
Posts: 14
Default Using "--" as an array formula shortcut / alternative
so what does
sumproduct(--(A1:A1000="West"),--(B1:B1000="Blue"),C1:C1000)
deferrer from
sumproduct((A1:A1000="West")*(B1:B1000="Blue")*(C1 :C1000))?
Reply With QuoteReply With Quote