software

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

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!

quot;msizquot; wrote:

gt; what formula do I use to total words? ie I have a column of TRUE and FALSE
gt; answers and I want to add up how many TRUE answers there are
gt; THanks


countif(range,true)

eg countif(a1:a50,true)

should work--
Dav
------------------------------------------------------------------------
Dav's Profile: www.excelforum.com/member.php...oamp;userid=27107
View this thread: www.excelforum.com/showthread...hreadid=502865And if you want to know what the percentage of the total are quot;truequot;, try
this........

=COUNTIF(A:A,quot;truequot;)/COUNTA(A:A)*100amp;quot;%quot;

Vaya con Dios,
Chuck, CABGx3
quot;msizquot; wrote:

gt; what formula do I use to total words? ie I have a column of TRUE and FALSE
gt; answers and I want to add up how many TRUE answers there are
gt; THanks

I think I'd just divide by 100 and format as percentage:

=(COUNTIF(A:A,quot;truequot;)/COUNTA(A:A))/100

Then it's still numeric.

CLR wrote:
gt;
gt; And if you want to know what the percentage of the total are quot;truequot;, try
gt; this........
gt;
gt; =COUNTIF(A:A,quot;truequot;)/COUNTA(A:A)*100amp;quot;%quot;
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt; quot;msizquot; wrote:
gt;
gt; gt; what formula do I use to total words? ie I have a column of TRUE and FALSE
gt; gt; answers and I want to add up how many TRUE answers there are
gt; gt; THanks

--

Dave Peterson

If one is going to reformat the cell as percentage, there is no need to
divide by 100.

Just
=(COUNTIF(A:A,quot;truequot;)/COUNTA(A:A))
formatted as percentage, will suffice

Vaya con Dios,
Chuck, CABGx3quot;Dave Petersonquot; wrote:

gt; I think I'd just divide by 100 and format as percentage:
gt;
gt; =(COUNTIF(A:A,quot;truequot;)/COUNTA(A:A))/100
gt;
gt; Then it's still numeric.
gt;
gt; CLR wrote:
gt; gt;
gt; gt; And if you want to know what the percentage of the total are quot;truequot;, try
gt; gt; this........
gt; gt;
gt; gt; =COUNTIF(A:A,quot;truequot;)/COUNTA(A:A)*100amp;quot;%quot;
gt; gt;
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt; quot;msizquot; wrote:
gt; gt;
gt; gt; gt; what formula do I use to total words? ie I have a column of TRUE and FALSE
gt; gt; gt; answers and I want to add up how many TRUE answers there are
gt; gt; gt; THanks
gt;
gt; --
gt;
gt; Dave Peterson
gt;

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

--

Dave Peterson

Oops. That didn't make sense, did it?

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

--

Dave Peterson