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))
Bookmarks