title: SQL adding numbers while handling nulls
body: <p>I have this statement here:</p>
  
  <pre><code>SELECT sum(table1.foo + table1.bar) AS Sum 
  FROM table1
  GROUP BY Fname;
  </code></pre>
  
  <p>When I try to add the numbers from foo and bar if one value from foo or bar is null it throws the numbers and gives me a different count sum</p>
  
  <pre><code>foo | bar
    6    4
    5    null
    9    1 
    2    1
    3    null
  </code></pre>
  
  <p>I want it to add all the numbers giving me a total of 31</p>
  
  <p>but in this case it gives me a total of 23
  Would love some help! Thanks!</p>