How to obtain count when multiple values are met

Hi there,

I have tried the forums and haven't been able to make any of the suggestions work for me.

I would like to count values if multiple criteria are met in the following situation:

1. I would like to count the unique values in column A UNLESS the first 3 numbers are the same. If the first 3 numbers are the same, I only want to count it once. (I can break out the numbers and letters into separate columns if needed.)
2. -and- if column B has a name (non-blank value)
3. -and- reference column C, so that the appropriate count pulls over to the key.

(A key is to the right of the attached spreadsheet where I would like the counts to show. They are separated into "Plan" categories.)

Thank you!

C