In this tutorial, you will learn how to count the number of cells containing booleans. TRUE CODE (TRUTH) i FALSE (FALSE) in Excel.
To count the number of cells that contain a value TRUE CODE (TRUE), use the following formula:
=COUNTIF(A1:A7,TRUE)
=СЧЁТЕСЛИ(A1:A7;ИСТИНА)
To count the number of cells containing a value FALSE (FALSE), use the formula below:
=CONTIF(A1:A7,FALSE)
=СЧЁТЕСЛИ(A1:A7;ЛОЖЬ)
To count the cells that contain TRUE CODE (TRUTH) or FALSE (FALSE), write this formula:
=COUNTIF(A1:A7,TRUE)+COUNTIF(A1:A7,FALSE)
=СЧЁТЕСЛИ(A1:A7;ИСТИНА)+СЧЁТЕСЛИ(A1:A7;ЛОЖЬ)