Use the COUNTIF formula to count the number of true cells if the cells are of boolean format. Use =COUNTIF(range, TRUE) to count the number of true cells.