Evaluate boolean values as 1 or 0

H

hmm

How do I use boolean values so that a formula would evaluate TRUE as 1 and
FALSE as 0? For example, if column A contains boolean values, I want to
avoid formulas like {SUM(IF(A1:A100, 1, 0))}. Instead, I would like to just
enter {SUM(A1:A100)}. Presently, in such a formula both TRUE and FALSE are
treated as 0.
 
D

Duke Carey

In addition to the other replies, you can:

force the formulas that evaluate to to TRUE or FALSE to evaluate to 1 or 0
by multiplying the result by 1, or use

=SUMPRODUCT(a1:a100*1)
 

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

SUMPRODUCT to substiute array formula 7
Trouble flagging conditions in Excel using VB 6
Avoiding redundant calculations 7
Continuation to equivalent for formula - to Mr. Harlan Grove (and notonly...) 1
OLD PROBLEM without SOLUTION , part || 1
Sum of cells, where there are not errors in them 8
Formula anomaly 7
Excel Macro to use cells as a autofilter 0

Top