Can you try COUNTIF function? Supposed that cells contained yr answers is
ranged from A1 to A10, then at A11:
=COUNTIF(A1:A10, TRUE)

Hope it helps!

"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 :)