title: Counting number of times value exceeded for a range of dates
body: <p>I have a list of wave heights measured hourly for every day in a year. All I want to do is have Excel count if the wave height exceeds a certain value (say, 6m in height) just once for a given day - that is, if the data says the wave height was over 6m three times on one day, it will just count that as a single occurrence. </p>
  
  <pre><code>Date    Wave Height
  
  1/1/98  1.99
  
  1/1/98  2.16
  
  1/1/98  2.21
  
  1/1/98  6.50
  
  1/1/98  6.71
  
  1/1/98  2.27
  
  1/1/98  2.31
  </code></pre>
  
  <p>In the above data set, I'd like the date 1/1/98 to have a "1" count since it exceeds 6m at least once, and I'd like this to continue all the way down for every date. 
  I've been trying to use countifs equations, but haven't been able to get it to do quite what I want. 
  This was the last one I tried: =COUNTIFS(H2:H8500,">=6",G2:G8500,"=$G2") where H is the  wave height column and G is the date column.
  Can anyone help me on this?</p>