title: How to count cells in a range with a value less than another cell in excel?
body: <p>My Table looks like below</p>
  
  <p><img src="https://i.stack.imgur.com/efXmU.jpg" alt="enter image description here"></p>
  
  <p>if "team1" value is less than "general" value in that month, then it has blue color,
  if "team2" value is less than "general" value in that month, then it has pink color,</p>
  
  <p>Now I want to count how many blue colored and how many pink colored cells on each row in a year (cells AK3 and AL3)</p>
  
  <p>What is the most appropriate formula for that?</p>