title: In SUMIFS function I am getting #VALUE error
body: <p><img src="https://i.stack.imgur.com/lU56N.jpg" alt="enter image description here">  </p>
  
  <p>For the top table above, I am using the following SUMIFS function:  </p>
  
  <pre><code>=SUMIFS($C$3:$G$23,$A$3:$A$23,"=Cinthol",$B$3:$B$23,"=Bangalore")  
  </code></pre>
  
  <p>to try to get the results in the output format shown, based on two criteria {1. Product and 2. City}.  But I am getting <code>#VALUE!</code> error. </p>
  
  <p>Am I doing something wrong?</p>