Counting number of TRUEs in a column

  • Thread starter Thread starter Jeff Granger
  • Start date Start date
J

Jeff Granger

Following on somewhat from a previous post, I have a column that contains
the text TRUE or FALSE. I need to count the number cells containing TRUE.

Suggestions?

Jeff
 
Following on somewhat from a previous post, I have a column that contains
the text TRUE or FALSE. I need to count the number cells containing TRUE.

Suggestions?

Jeff
Click to expand...

=COUNTIF(B:B,TRUE)
--ron
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
Coverting TRUE to 1 2
MACRO RUN random percentage and copy of column values 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
SUMIFS ONLY UNTIL the number REPEATS 1
Split column contents (de-concantenate) 7
Count Values in a Range, Not Formulas 2
Count number of cells containing a specific date range 7

Back
Top