counting TRUEs and FALSEs

M

mitcheroo

A large range of cells (6 columns by 400 rows) all contain an
OR-function formula and all display a TRUE or FALSE value. (Results
based on processing of a nearby range of data.)

I want to count how many TRUEs occur in each row, and display the
result for each row in the 7th column. I'm having trouble figuring this
one out, since all the functions I've looked at so far apparently see
only the formula and not the value.
 
D

Dave Peterson

=countif(a1:f1,TRUE)

should work.

A large range of cells (6 columns by 400 rows) all contain an
OR-function formula and all display a TRUE or FALSE value. (Results
based on processing of a nearby range of data.)

I want to count how many TRUEs occur in each row, and display the
result for each row in the 7th column. I'm having trouble figuring this
one out, since all the functions I've looked at so far apparently see
only the formula and not the value.
Click to expand...
 

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

Remove Identical words 0
#VALUE error which disappears when I use F2, ENTER 1
Need "true" or "false" 4
Sum of Numbers of a Rolling 6 month Period range 0
Track Count of Boolean Field in Pivot Table 0
Error in Copying "Exact" Function 1
Help linking true false in column to start macros 3
Display values other than TRUE and FALSE 6

Top