I need to count cells which meet 2 sets of criteria and am trying to use the countifs function.
Range 1, Criteria referenced in cell Z9 (eg. Cracked cell)
Range 2, Criteria referenced in cell AA8 (eg. Minor)
This is the formula I am using which seems to be giving me a "#VALUE!" error.
Please help rectifying.