Excel function TRUE FALSE?

Question

I have several columns that contain only True or FALSE in the cells. I want to insert a function that will automatically add the number of TRUE statements in each column. How do I write that function?

Answer 1

Use the COUNTIF function.  Let's pretend your range is A1:C30 -- so to count "TRUE" the function would be:

=COUNTIF(A1:C30,"TRUE")