Analyzing logical value results
 

Hi guys
Do any of you know of a function that will do the same job as the
Frequency array function, but will analyze true/false results instead
of numbers?

I got a column of results in my spreadsheet that contain just logical
true or false results, and I would like to count up how many true
results and false results there are in that column. Every formula that
I try keeps asking me for numbers.

tia
J

Analyzing logical value results
 

Apologies, my name field was suppressed for the last post...

On Tue, 20 Feb 2007 20:10:25 +0000, wrote:

Hi guys
Do any of you know of a function that will do the same job as the
Frequency array function, but will analyze true/false results instead
of numbers?

I got a column of results in my spreadsheet that contain just logical
true or false results, and I would like to count up how many true
results and false results there are in that column. Every formula that
I try keeps asking me for numbers.

tia
J

Analyzing logical value results
 

Did you try the COUNTIF() function?

=COUNTIF(A1:A100,TRUE)

or

=COUNTIF(A1:A100,FALSE)

HTH,
Elkar


" wrote:

Hi guys
Do any of you know of a function that will do the same job as the
Frequency array function, but will analyze true/false results instead
of numbers?

I got a column of results in my spreadsheet that contain just logical
true or false results, and I would like to count up how many true
results and false results there are in that column. Every formula that
I try keeps asking me for numbers.

tia
J

Analyzing logical value results
 

Hi Elkar, thanks for the prompt reply

That works a treat, I appreciate the suggestion. I admit that I am not
familiar with every Excel function and I plead guilty to not finding
that particular one in the help files.

Thanks again.
J

On Tue, 20 Feb 2007 12:25:20 -0800, Elkar
wrote:

Did you try the COUNTIF() function?

=COUNTIF(A1:A100,TRUE)

or

=COUNTIF(A1:A100,FALSE)

HTH,
Elkar


" wrote:

Hi guys
Do any of you know of a function that will do the same job as the
Frequency array function, but will analyze true/false results instead
of numbers?

I got a column of results in my spreadsheet that contain just logical
true or false results, and I would like to count up how many true
results and false results there are in that column. Every formula that
I try keeps asking me for numbers.

tia
J

Analyzing logical value results
 

Apologies, I have no idea what is going on with my newsreader. It is
now broadcasting the wrong nic.

the above post is actually from me, thanks again Elkar
J