formula
I was guessing that the OP may want to see .10 as 10%.
CLR wrote:
If one is going to reformat the cell as percentage, there is no need to
divide by 100.
Just
=(COUNTIF(A:A,"true")/COUNTA(A:A))
formatted as percentage, will suffice
Vaya con Dios,
Chuck, CABGx3
"Dave Peterson" wrote:
I think I'd just divide by 100 and format as percentage:
=(COUNTIF(A:A,"true")/COUNTA(A:A))/100
Then it's still numeric.
CLR wrote:
And if you want to know what the percentage of the total are "true", try
this........
=COUNTIF(A:A,"true")/COUNTA(A:A)*100&"%"
Vaya con Dios,
Chuck, CABGx3
"msiz" wrote:
what formula do I use to total words? ie I have a column of TRUE and FALSE
answers and I want to add up how many TRUE answers there are
THanks :)
--
Dave Peterson
--
Dave Peterson
|