Using curly braces array in an IF formula but referencing a table.

[Paul_K]

I have a formula using a curly braces array:

=SUM(COUNTIFS(RequestExtract[P],F$13, RequestExtract[Resolution],{"New","Validated","In progress","Test failed"} ))

Veriations on this formula are used in multiple places in the workbook and I want to be able to easlly add or remove values from the array.
Is there a way to do this sort of thing but referencing a table rather than an array in the formula. Something like:

RequestExtract[Resolution], {TableName[ColumnName]}

Thanks in advance for any help, this one has me stumped.

 

[Fluff]

Yes you can do that, but do not include the curly braces.

 

[Paul_K]

Yes you can do that, but do not include the curly braces.

Oh, that's so simple I didn't even think to try it. Thank you, working perfectly!

=SUM(COUNTIFS(RequestExtract[Severity],$B8,RequestExtract[P],F$13,RequestExtract[Resolution], Config_Status[Open]))

 

[Fluff]

You're welcome & thanks for the feedback.