count number of cells contain logical values

[Kwnstantinos_M]

Hello

I have a column with logical values (true, false). I used countif command to count the number of those cells, but the outcome was zero..

The command I used is:

=COUNTIFS(R2:R5433;"TRUE";R2:R5433;"FALSE")

I also wrote the above command without the second criteria (for false) and I got an answer.. I seems to work for 1 criteria but not for two. Do you have any idea why?

 

[sheetspread]

Try:

Excel 2010
	I
105	TRUE
106	2
107	TRUE
108	FALSE
109	TRUE
110	FALSE
111	TRUE
112	1
113	FALSE
114	FALSE
115	FALSE
116	TRUE
117	FALSE
118	5
119	TRUE
120
121
122	12
Sheet1

Cell Formulas
Range	Formula
I122	=SUMPRODUCT(0+ISLOGICAL(I105:I119))

=SUM(COUNTIF(I105:I119,{TRUE,FALSE}))

works too

 

[Kwnstantinos_M]

Perfect!! Thank very very very much!!!!