AverageIfs Issue

[BWMagee]

Hi, I'm wondering what's wrong with my AVERAGEIFS formula:

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'; color: #000000}span.s1 {color: #0057d6}</style>{=AVERAGEIFS('2018F'!$AF$8:$AF$6693,'2018F'!$M$8:$M$6693,PvO!$D133,'2018F'!$R$8:$R$6693,">=55",'2018F'!$J$8:$J$7000,"T6T")}

When I take out the last part ( '2018F'!$J$8:$J$7000,"T6T" ) it works, and returns a value. But when I include that last part, it returns #VALUE !

"T6T" is text in Column J. That text is actually returned by its own formula, and {INDEX/MATCH}. I wondered if the AVERAGEIFS didn't like reading from an array formula, but when I overwrite the {INDEX/MATCH} with the text string "T6T", my AVERAGEIFS formula still returns the #VALUE ! error. I also tried overwriting it with "6", and adjusting the AVERAGEIFS formula accordingly, but still I got value #VALUE .

So I'm not sure what I'm doing wrong. Any help much appreciated.

 

[jorismoerings]

For these formula evaluation ranges should be equal.

{=AVERAGEIFS('2018F'!$AF$8:$AF$6693,'2018F'!$M$8:$M$6693,PvO!$D133,'2018F'!$R$8:$R$6693,">=55",'2018F'!$J$8:$J$7000,"T6T")}

change it to:

{=AVERAGEIFS('2018F'!$AF$8:$AF$6693,'2018F'!$M$8:$M$6693,PvO!$D133,'2018F'!$R$8:$R$6693,">=55",'2018F'!$J$8:$J$6693,"T6T")}

 

[BWMagee]

For these formula evaluation ranges should be equal.

{=AVERAGEIFS('2018F'!$AF$8:$AF$6693,'2018F'!$M$8:$M$6693,PvO!$D133,'2018F'!$R$8:$R$6693,">=55",'2018F'!$J$8:$J$7000,"T6T")}

change it to:

{=AVERAGEIFS('2018F'!$AF$8:$AF$6693,'2018F'!$M$8:$M$6693,PvO!$D133,'2018F'!$R$8:$R$6693,">=55",'2018F'!$J$8:$J$6693,"T6T")}

Brilliant, thank you!

They were all 7000 to start with, not sure who they changed considering they have the $ on them - think it is either something to do with sorting and/or deleting rows from the sheet ('2018F') they are reading from.