title: Embedding LEFT in an AVERAGEIFS formula
body: <p>Hi I'm trying to use an AverageIFS formula to work out the average performance by month and by territory but I'm struggling to get it to work.</p>
  <p>I can get it to work as individual IF functions but together it's just returning #VALUE!</p>
  <p>The formula seen in cell C28 is <code>=AVERAGEIFS(2:25,BDPercentage[[#All],[Territory]],$B28,2:2,LEFT(C27,3)&amp;&quot;*&quot;)</code></p>
  <p>See in Cell C30 I manage to get it to Average just the Januarys for the first line of the table using this code <code>=AVERAGEIF(2:2,LEFT(C27,3)&amp;&quot;*&quot;,3:25)</code>, although even that is just returning the top line of the table when I would have thought it would average all the data available for January?<a href="https://i.stack.imgur.com/CXrWw.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CXrWw.png" alt="enter image description here" /></a></p>
  <p>NOTES:
  The table in the screenshot is called &quot;BDPercentage&quot;
  Row 2 consists of Date fields</p>