'Embedding LEFT in an AVERAGEIFS formula
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.
I can get it to work as individual IF functions but together it's just returning #VALUE!
The formula seen in cell C28 is =AVERAGEIFS(2:25,BDPercentage[[#All],[Territory]],$B28,2:2,LEFT(C27,3)&"*")
See in Cell C30 I manage to get it to Average just the Januarys for the first line of the table using this code =AVERAGEIF(2:2,LEFT(C27,3)&"*",3:25), 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?
NOTES: The table in the screenshot is called "BDPercentage" Row 2 consists of Date fields
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|