title: On a spreadsheet what does A:A and !A:A mean?
body: <p>I have come across this sumif formula, I cant find any help doing a Google search on the <code>N:N</code></p>
  
  <pre><code>=sumif(N:N,"Cat",C:C)
  </code></pre>
  
  <p>So I understand the SumIf, as per the docs:</p>
  
  <pre><code>SUMIF(range, criterion, [sum_range])
  </code></pre>
  
  <p>But I don't fully understand the <code>N:N</code>. Also please explain <code>!A:A</code></p>
  
  <p>Can someone provide an official explanation or point me to the docs.</p>