Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
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 :) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
Can you try COUNTIF function? Supposed that cells contained yr answers is
ranged from A1 to A10, then at A11: =COUNTIF(A1:A10, TRUE) Hope it helps! "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 :) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
countif(range,true) eg countif(a1:a50,true) should work -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=502865 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
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 :) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
Oops. That didn't make sense, did it?
Dave Peterson wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Hide formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Help with macro formula and variable | Excel Worksheet Functions |