title: How to use Countif function to count rows that has a specific value in either of column A or B in Google sheet?
body: <p>I am trying to count the number of rows that has a specific value let say &quot;John&quot; in either Column C or Column D. If the two columns have both the same value, then only one of them is counted.</p>
  <p>Here is the example sheet. column C &amp; D has the data.
  Column G contains the function countif</p>
  <p><a href="https://docs.google.com/spreadsheets/d/1i9I2bhtlHAMWqVqdE7hbkgLRLCCUrfnOMSQcf9Gj4_0/edit#gid=0" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1i9I2bhtlHAMWqVqdE7hbkgLRLCCUrfnOMSQcf9Gj4_0/edit#gid=0</a></p>