title: SUMIFS Formula giving wrong result for calculating YTD-1 Value
body: <p>I tried to sum up all the months until the current month. However, the formula is not working. .</p>
  <p>I get a 0 for all rows.</p>
  <p>Can somebody help me figure out where the problem is?</p>
  <pre><code>=SUMIFS(H4:AS4;$H$2:$AS$2;&quot;&lt;=&quot;&amp;MONTH(TODAY());$H$1:$AS$1;YEAR(TODAY())-1)
  </code></pre>
  <p><a href="https://i.stack.imgur.com/5HCCV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5HCCV.png" alt="enter image description here" /></a></p>