Referencing criteria listed in column with COUNTIFS function

Hello,

Instead of one of my countifs criteria listing the long list of decision codes highlighted below in red, how can I reference that criteria that is in { } if it is listed in a table based on its different classification, that is the label assigned to that the specified group of codes. Thanks for the help

=SUM(COUNTIFS(Table[Correct Type],$A5,TargetX[Latest Decision],{"CO","CC","DA","DD","DF","DP","DW","IE","NS","PR","PW","RJ","RW","SD","SM","WA","WD","WI","WL","WN","WO","WP","WS"},Table[Date],"<="&$A$1))

Here is an example file of what I am trying to do. Essentially the range of text criteria I would want to name or reference reflects "or" logic so to speak, that is all records that contain any one of the text codes within that referenced range of criteria gets counted. Thanks for the help!



CountIFs_range_critera.xlsx

Try this in B4

=SUMPRODUCT(COUNTIFS(Records[Date],"<="&$C$1,Records[Gender],A4,Records[Code],Codes[Completed]))

Change Completed to Reviewed and Accepted for C4 and D4

^ Easiest fix. Should have thought to try with sumproduct myself. Thanks

You're welcome.