I am trying to count the number of rows that has a specific value let say "John" in either Column C or Column D. If the two columns have both the same value, then only one of them is counted.

Here is the example sheet. column C & D has the data. Column G contains the function countif