Good Evening,

I figured out how to pull out the numeric character from the A & P Deliverables column, which currently has 9. No Deliverables and 1. Partnered/hosted to pull into the Count (A&P) Deliverables - 9 Column, see below.

The issue, see next image, is I am attempting to link the numeric values that are outputted in Count (A&P) Deliverables - 9 column to another sheet to execute the COUNTIFS function to count only the outputs that equal 9 in column All Deliverables Met, unfortunately it is not working as you can see that its counting the 1 and the empty cells as 1. If I understand correctly anything that is not equal to 9 should be blank, thus why I think the COUNTIFS formula is incorrect.

Thanks for taking the time to apply your brilliant minds to the simple question.

Thanks,

NCNWInc.