Thread: Countif accross multiple questions.
View Single Post
  #2   Report Post  
Dave O
 
Posts: n/a
Default Countif accross multiple questions.
Did you use double unary operators in the SUMPRODUCT formula? I got
this one to work:
=SUMPRODUCT(--(D1:D5=TRUE),--(E1:E5=0))

Reply With QuoteReply With Quote