title: Identify average number of signal in a one-minute trade dataset in EXCEL
body: <p>I have a strategy modeled in excel and generated buy/sell signals based on a one minute market data.</p>
  
  <p>I would like to know the average number of signals generated in an hour.  The data looks like this.</p>
  
  <p><a href="https://i.stack.imgur.com/SLuaM.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/SLuaM.jpg" alt="Excel sampe data in image format"></a></p>
  
  <p>Thanks for your help.</p>
  
  <p>I am trying to avoid any complex usage of user defined functions. </p>
  
  <p>regards
  Gopal</p>