View Single Post
  #3   Report Post  
Bernard Liengme
 
Posts: n/a
Default

=SUMPRODUCT(--(A1:A9))=COUNTA(A1:A9)
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Arla M" wrote in message
...
What kind of formula would I use to "add" a list of true false statement
to
return TRUE if they are all true, and FALSE if even one is false. Thanks.