SUMIFS, COUNTIFS, & SUMPRODUCT - With multiple cell ranges & criteria

Hey Guys!
I'm trying to count multiple ranges that contain a specific letter & another set of ranges contain a letter into one specific cell. BUT when I add multiple ranges, its sending back #VALUE!. This is what i have for the 1 range, but need to to read off of multiple ranges.
=SUMPRODUCT(--($C$4:$C$30="cg"),--($B$4:$B$30="P"))

This is what I need:
if ranges C4:C30, F4:F30, I4:I30, L4:L30, O4:O30, R4:R30, U4:U30 contain "CG"
AND
ranges b4:B30, e4:E30, h4:H30, k4:K30, n4:N30, q4:Q30, t4:T30 contain "P"
THEN
the count is 4 (in cell Z21)

Here's one way:

Please Login or Register  to view this content.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

I do not understand the last request (post #5). If I delete the contents of B4 then cell Z21 displays 3 so it would appear that CARACALLA's formula is already fulfilling the request.
Let us know if you have any questions.