title: counting the number of rows on a table containg data
body: <p>In googlesheets i'd like a formula that looks at an entire table and for each row that contains data it comes back as 1, and adds all those 1s togteher.  All I;ve come up with some far is a formula that repeats the action of looking at one</p>
  <p>ie</p>
  <p>(if(COUNT(IMPORTRANGE($C11,($D11&amp;&quot;!&quot;&amp;(HLOOKUP((match(K$1,(IMPORTRANGE($C11,($D11&amp;&quot;!$A$3:$ZZ$3&quot;))) ,0)),Lookups!$7:$8,2))&amp;&quot;6:&quot;&amp;(HLOOKUP((match(L$1,(IMPORTRANGE($C11,($D11&amp;&quot;!$A$3:$ZZ$3&quot;))) ,0))-1,Lookups!$7:$8,2))&amp;&quot;6&quot;)))&gt;0,1,0))+</p>
  <p>(if(COUNT(IMPORTRANGE($C11,($D11&amp;&quot;!&quot;&amp;(HLOOKUP((match(K$1,(IMPORTRANGE($C11,($D11&amp;&quot;!$A$3:$ZZ$3&quot;))) ,0)),Lookups!$7:$8,2))&amp;&quot;7:&quot;&amp;(HLOOKUP((match(L$1,(IMPORTRANGE($C11,($D11&amp;&quot;!$A$3:$ZZ$3&quot;))) ,0))-1,Lookups!$7:$8,2))&amp;&quot;7&quot;)))&gt;0,1,0))+</p>
  <p>(if(COUNT(IMPORTRANGE($C11,($D11&amp;&quot;!&quot;&amp;(HLOOKUP((match(K$1,(IMPORTRANGE($C11,($D11&amp;&quot;!$A$3:$ZZ$3&quot;))) ,0)),Lookups!$7:$8,2))&amp;&quot;8:&quot;&amp;(HLOOKUP((match(L$1,(IMPORTRANGE($C11,($D11&amp;&quot;!$A$3:$ZZ$3&quot;))) ,0))-1,Lookups!$7:$8,2))&amp;&quot;8&quot;)))&gt;0,1,0))+</p>
  <p>and so on</p>