View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
s2m via OfficeKB.com s2m via OfficeKB.com is offline
external usenet poster
 
Posts: 30
Default SUMPRODUCT Question

When writing a Sumproduct formula, what does ,-- mean?

I know you can use +, what other symbols can you use?

Are there and's or or's symbols?


=SUMPRODUCT(--(Odyssey!$E$2:$E$898=B42),--(Odyssey!$AH$2:$AH$898="N")+
(Odyssey!$AQ$2:$AQ$898 <""))

Sharon

--
Message posted via http://www.officekb.com