Thread: how to disregard the DIV in a range
View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default
Take a look at

http://www.mcgimpsey.com/excel/doubleneg.html


In article ,
"CMAC" wrote:

and what does the "--" mean in this formula?
=SUMPRODUCT(--($C$11:$C$36="n"),($D$11:$D$36*P$11:P$36))
Reply With QuoteReply With Quote