Calculation Formula COUNTIF Text Field
Having an issue with getting a formula to work. Trying to count the number of matches using "=" against a text field
The reference points to a text field, which will have one of P1, P2, P3 in it. When I try to COUNTIF the field with "=P1" to get a count of the number of "P1" controls, it errors.
Field Name: Family P1 Control Count
Field ID: Family_P1_Control_Count
Calculation Error: The column was outside the expected range.
Formula: COUNTIF(REF([Control Workbook Reference(s)],[Control Standard NIST Priority]),"=P1" )