Hi,

I'm using the Average array formula to calculate average for certain values with specific months and year

=AVERAGE(IF(YEAR($C$4:$C$14)=Z9;IF(MONTH($C$4:$C$14)=AA9;$F$4:$F$14;""));"")

The two first IF just checks whether it is the right month and year. The last bit gets the numbers, that is going to make up the average. However my problem it seems is that the average also includes Not true = "", when calculating the average.