title: How can I use SUM for bit columns?
body: <p>How can use the function SUM() for bit columns in T-SQL?</p>
  
  <p>When I try do it as below:</p>
  
  <pre><code>SELECT SUM(bitColumn) FROM MyTable;
  </code></pre>
  
  <p>I get the error:</p>
  
  <blockquote>
    <p>Operand data type bit is invalid for sum operator.</p>
  </blockquote>