Array formulas using structured references?

Hello everyone,

I've been trying to set up an array formula for MEDIAN IF. The formula looks like this at present:

=AVERAGE(IF(AND(Table[Range1]="Criteria1", Table[Range2]="Criteria2", Table[Range3]="Criteria3"), Table[Values to calculate the Median]))

Basically, I have need to operate the IF on 3 criteria, and my data source is structured as a named table*

*Because the data is dynamic and it might be 600 rows one time, or 100000 another time, plus it's easier to "see" what I'm filtering

The formula is not working at present, gives #N/A error.

Questions:
1. Can I use array functions on structured references (i.e: tables)?
2. Is the above formula alright?

This is one way to make it work:

=AVERAGE(IF(Table1[ColA]="B",IF(Table1[ColB]="X",IF(Table1[ColC]="G",Table1[ColC2]))))

entered as an array formula. Array Formulae are a little different from ordinary formulas in that they MUST be confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.

You will know the array is active when you see curly braces { } appear around the outside of your formula. If you do not CTRL+SHIFT+ENTER you will (almost always) get an error message or an incorrect answer. Press F2 on that cell and try again.

Don't type the curly braces yourself - it won't work...

Thank you Glenn and Jonmo1 (very much like that true/false multiplier solution!), both work perfectly on sample data but still not working on my sheet.

It's a bit weird. I've done the following test:
1. Filtered my table to only show the criteria I want met
2. Copied the remaining rows (72 of them) onto another sheet
3. Made a table with these ("Table2")

If I run either solution on Table2, everything works like a charm. If I try it on my original table, however, I get error.

Would it matter if one of my criteria is set to be an integer, but some values in that column are strings? (I'm guessing the operator would just give a FALSE for that instance).

Or might it be more to do with my original table having ~7000 rows?

Sorry, just a bit baffled on why it's working on a sample of the data, but not on the entire table

I'll keep testing and see if anything comes up. Any idea welcome, and thank you already for the great solutions!

EDIT:

Problem solved. One of my rows had an error (#N/A) in a cell, which screwed up everything. THANK YOU EVERYONE!