title: How can I count the rows with data in an Excel sheet?
body: <p>I am trying to count the number of rows in a spreadsheet which contain at least one non-blank value over a few columns: i.e.</p>
  
  <pre><code>row 1 has a text value in column A
  row 2 has a text value in column B
  row 3 has a text value in column C
  row 4 has no values in A, B or C
  </code></pre>
  
  <p>The formula would equate to 3, because rows 1, 2, &amp; 3 have a text value in at least one column. Similarly if row 1 had a text value in each column (A, B, &amp; C) this would be counted as 1.</p>