And if you want to know what the percentage of the total are "true", try
this........

=COUNTIF(A:A,"true")/COUNTA(A:A)*100&"%"

Vaya con Dios,
Chuck, CABGx3



"msiz" wrote:

what formula do I use to total words? ie I have a column of TRUE and FALSE
answers and I want to add up how many TRUE answers there are
THanks :)