title: If Statement & Countif combined
body: <p>in column B I have "CM" in a range =COUNTIF(B:B,"CM") will return the total count of all cells that contain "CM" </p>
  
  <p>I need to take it one more step. where column B contains CM I need to count the range in column H only if the range in H has data/text</p>
  
  <p>Thanks 
  David</p>