countif

[jasman]

Hi. I have f4 columns with "TRUE" & "FALSE" values in them. I am tryign to do a countif at the bottom of each to see how many "TRUE" vales there are in each column. Im using formula below but it only works for one of the columns and wont count the "TRUE"s in the other ...just gives answer as 0?

=COUNTIF(O7:O122,"TRUE")

 

[grizz]

If you want to count the "True's" in 4 columns your formula must include all columns such as

=countif(L7:O122,"true")

 

[jasman]

sorry i wasnt clear.... im doing the countif for each column at the bottom so I have four seperate counts

 

[grizz]

then for column L it would be

=COUNTIF(L7:L122,"TRUE")

column M would be

=COUNTIF(M7:M122,"TRUE")

and so on

 

[njimack]

If the TRUE's are a result of a formula, you won't need to put them in quotes:
=COUNTIF(O7:O122,TRUE)

 

[jasman]

thats exactly what ive done but it doesnt work, only works for column O.

i have formulas in each of the columns which calculate the TRUE or FALSE outcome. could this have an affect?

 

[grizz]

no --- if there is a "true" in the column the formula should count it -- check your spelling to make sure it is correct

 

[njimack]

thats exactly what ive done but it doesnt work, only works for column O.

i have formulas in each of the columns which calculate the TRUE or FALSE outcome. could this have an affect?

Post the formula you currently have that returns TRUE or FALSE.

 

[jasman]

ive checked and double checked its all consistent. the onyl thing is that column O has countif formula in it to caculate the TRUE or FALSE values, whereas the others are IF statements.

Thanks for your help...its driving me mad! :S

 

[grizz]

Have you tried changing the "True" in your formula to "False" to see if it will count them