Count Areas with a formula

[Stephen_IV]

I am trying to count areas with a formula. Please see below. Thanks in advance!



<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}
</style>
<table class="tableizer-table">
<thead><tr class="tableizer-firstrow"><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th><th>K</th><th>L</th><th>M</th><th>N</th><th>Count </th></tr></thead><tbody>
<tr><td>12</td><td>32</td><td> </td><td> </td><td>43</td><td> </td><td> </td><td> </td><td>54</td><td>45</td><td>67</td><td>78</td><td>98</td><td>3</td><td>3</td></tr>
<tr><td>12</td><td>12</td><td> </td><td>34</td><td>5</td><td> </td><td>32</td><td>54</td><td> </td><td>54</td><td>45</td><td> </td><td>3</td><td>3</td><td>5</td></tr>
<tr><td>12</td><td> </td><td>12</td><td> </td><td> </td><td>12</td><td> </td><td>2</td><td> </td><td>2</td><td> </td><td>12</td><td>12</td><td>12</td><td>6</td></tr>
</tbody></table>

 

[Tetra201]

If you can have an empty column (that might be hidden) after the last column of you dataset (empty column O in this example), then try

=COUNTIFS(A2:N2,"<>",B2:O2,"")

 

[Stephen_IV]

Tetra201 that works! Thank you so much. I greatly appreciate it.