=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.