Custom Data Validation

So there are two hygiene things I want to address before we address the substance of the question.

1) You've got a superfluous SUM wrapped around the SUMIFS there; it's just adding up one number and returning the total, which is the number it's given.

2) Feeding a formula the whole entire column, eg X:X instead of X1:X1000 or some big range, is a bad habit. It forces the formula to examine every single row, all millions of them.

This isn't a big deal exactly, but it's something that people (like me) are going to either silently correct in their formula suggestions, or mention (like me).

Moving on to the substance, I don't actually quite understand what you're asking for.

You're not referencing C4 in the SUMIFS, so I think there's a logical flaw in the design here?

And I'm not understanding what "sum anything with both CC & PP listed" means. Like, do you want it to check column CC as well as PP? What is the logical relationship here? If you want to embed some Boolean logic inside the SUMIFS, we'll probably move you to a SUMPRODUCT construction, but it might be as simple as just adding another term to the SUMIFS.