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

Making a macro only work on certain files 2
Word macro that can call cells out of Excel for a find and replace 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
VBA Coding Help for Beginner 0
VBA word change keys 0
Change a great number of words in word files, with a macro as short as possible. 5
SUMPRODUCT to substiute array formula 7
Avoiding redundant calculations 7

Top