Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Analyzing Numbers | Excel Discussion (Misc queries) | |||
Analyzing a sub-totalled list | Excel Discussion (Misc queries) | |||
Excel should speak results of logical formula | Excel Worksheet Functions | |||
analyzing survey date | Excel Worksheet Functions | |||
My IF(AND passes logical, but doesn't reveal correct results | Excel Worksheet Functions |