View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elkar Elkar is offline
external usenet poster
 
Posts: 964
Default 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