Averageifs

[johns99]

Having issues with the below formula

=AVERAGEIFS($CY$6:$CY$7808,$W$6:$W$7808,"x",$W$6:$W$7808,"+")

I'm trying to get an average for anything in column W with a "x" or "+"

any thoughts on this?

thanks,

John

 

[johns99]

That's correct, the blanks are blank returned by a formula...this is definitely the reason why the numbers are different. Thanks!

 

[barry houdini]

{=AVERAGE(IF($CQ$6:$CQ$7808={"P6","M5"},$CY$6:$CY$7808))}

Are "P6" and "M5" actual test values or cell references?

 

[johns99]

They are actually text values.

 

[XOR LX]

That's correct, the blanks are blank returned by a formula...this is definitely the reason why the numbers are different. Thanks!

Ah. Of course. I should've considered that possibility.

Regards

 

[johns99]

Sorry...I mean test values

 

[barry houdini]

No, you were right, I meant "text"

That formula looks OK - If you get #N/A then you might have #N/A in one of the ranges......or you mistyped the ranges and they aren't the same size

 

[johns99]

You were right!! There was a #N/A in the range...

This forum is beyond helpful and has helped me out of so many jams...thank you all so much for your assistance today!

Regards,
John