title: Get Sum of the Count column
body: <p>i want to display on top of the page total no of critical items and below the list. This is my query</p>
  
  <pre><code>SELECT  vs.vessel_name, vs.CallSign ,COUNT(IF(m.AvailableQuant &lt;= m.MinQuant,1, NULL)) AS 'Critical'                
  FROM tbl_vesselmaster vs
  INNER JOIN comp_login cl ON vs.co_id = cl.id
  INNER JOIN m_shipinv m ON vs.id = m.ShipId
  WHERE vs.co_id=123
  GROUP BY vs.id, vs.vessel_name ;
  </code></pre>
  
  <p>this is the output</p>
  
  <pre><code>vessel_name  CallSign  Critical_Items  
  -----------  --------  ----------------
  Sima Sadaf   (NULL)                   4
  sdare        3q1                      1
  </code></pre>
  
  <p>I want to display on top of the page the total no of critical items i.e 5 items are critical
  how do i get the sum? </p>