title: How to count rows greater than a value and write the count to a text file in Linux
body: <p>I have a file with sample data shown below:</p>
  
  <pre><code>%_above_10 %_above_20 %_above_30 %_above_50
  88.6    88.1    87.8    87.2
  89.1    78.5    72.3    59.4
  100.0   100.0   100.0   100.0
  100.0   100.0   100.0   100.0
  100.0   100.0   70.0   80.0
  100.0   100.0   100.0   80.0
  100.0    31.9    26.8    17.4
  00.0   96.0    77.3    43.3
  68.8    65.9    63.6    57.1
  </code></pre>
  
  <p>I need to count the rows in each column which have value 100 and write it to a text file. The output could look like:</p>
  
  <pre><code>Totalrows %_above_10 %_above_20 %_above_30 %_above_50
     9        5            4          3         2
  </code></pre>
  
  <p>I am able to count one column at a time using the basic awk command:</p>
  
  <pre><code>awk -F "\t" '{if($1 == 100)print;}
  </code></pre>
  
  <p>Could anyone suggest a way to count the columns in the above specified way and write to a file using linux commands or script (awk). Thanks</p>