Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Counting Textual Answers
I want to Count and Total the results of a string of Text cells where Yes=1
and No=0. How do I establish the parameters for Yes and No to equal a numeric result and then Total the result without creating a Macro? The text answer needs to be visible: it is the result of a Yes/No choice. |
#2
|
|||
|
|||
Hi
Alongside the Y/N column use a helper column containing: =IF(A2="Yes",1,0) You can then use this column for your total. Andy. "Lowkey" wrote in message ... I want to Count and Total the results of a string of Text cells where Yes=1 and No=0. How do I establish the parameters for Yes and No to equal a numeric result and then Total the result without creating a Macro? The text answer needs to be visible: it is the result of a Yes/No choice. |
#3
|
|||
|
|||
Do the count and total in one step
=COUNTIF(A:A,"Yes") =COUNTA(A:A)-COUNTIF(A:A,"Yes") -- HTH Bob Phillips "Andy B" wrote in message ... Hi Alongside the Y/N column use a helper column containing: =IF(A2="Yes",1,0) You can then use this column for your total. Andy. "Lowkey" wrote in message ... I want to Count and Total the results of a string of Text cells where Yes=1 and No=0. How do I establish the parameters for Yes and No to equal a numeric result and then Total the result without creating a Macro? The text answer needs to be visible: it is the result of a Yes/No choice. |
#4
|
|||
|
|||
Assumin the Yes and No are in separate cells like if the were in B1:B200 and
you want to count Yes =COUNTIF(B1:B200,"Yes") since you only want 1 for Yes you can just count them and the result should be OK Regards, Peo Sjoblom "Lowkey" wrote: I want to Count and Total the results of a string of Text cells where Yes=1 and No=0. How do I establish the parameters for Yes and No to equal a numeric result and then Total the result without creating a Macro? The text answer needs to be visible: it is the result of a Yes/No choice. |
#5
|
|||
|
|||
Both Andy's and Peo's suggestions work, but I like Peo's better because I
don't have to create a dummy column and hide it. "Peo Sjoblom" wrote: Assumin the Yes and No are in separate cells like if the were in B1:B200 and you want to count Yes =COUNTIF(B1:B200,"Yes") since you only want 1 for Yes you can just count them and the result should be OK Regards, Peo Sjoblom "Lowkey" wrote: I want to Count and Total the results of a string of Text cells where Yes=1 and No=0. How do I establish the parameters for Yes and No to equal a numeric result and then Total the result without creating a Macro? The text answer needs to be visible: it is the result of a Yes/No choice. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting rows of blanks across certain columns | New Users to Excel | |||
Counting... | Excel Worksheet Functions | |||
counting Multiple answers in 1 cell + column | Excel Discussion (Misc queries) | |||
counting Multiple answers in 1 cell + column | Excel Discussion (Misc queries) | |||
Counting data by certain years | Excel Worksheet Functions |