Help with COUNTA formula

[HDfatboy03]

Hello

Working in excel 2007 and I am trying to use "COUNTA" to count how many "TRUE"'s I have in a range. This is what I have but it's not working. What am I missing?

=COUNTA(C10:K10)

Any help or suggestions will be greatly appreciated.

HDfatboy03

 

[AnAnalyst]

Try this ...

=COUNTIF(C10:K10,TRUE)

 

[jasonb75]

COUNTA just counts number of populated cells.

Try =COUNTIF(C10:K10,"true") instead.

 

[HDfatboy03]

Thanks so much ... it works now ... You are awesome