title: TRUE and FALSE don't work within SUM()
body: <p>I have boolean values in a column:</p>
  
  <pre><code>   A
  1  TRUE
  2  FALSE
  3  TRUE
  4  TRUE
  </code></pre>
  
  <p>I realize that in Excel <code>=TRUE+TRUE</code> returns <code>2</code> and <code>=TRUE+FALSE</code> returns <code>1</code> which implies <code>TRUE</code> is equal to <code>1</code> and <code>FALSE</code> is equal to <code>0</code>. However, <code>SUM(A1:A4)</code> always returns <code>0</code> no matter whether it is array formula style... I would expect it to be <code>3</code> (the number of <code>TRUE</code> in the range).</p>
  
  <p>One way to get <code>3</code> is to use <code>{=SUM(IF(A1:A4,1,0))}</code> (array formula style), which I find redundant... Could anyone think of a simpler solution than that?</p>