I had just posted a question that was answered, so I tried to make it easier
to understand the formula for whomever takes over for me and defined the
columns as REDCAT, Gender, and Grade doing InsertNameDefine.

The formula works fine like this:
=SUMPRODUCT(--('By-Name Population'!D2:D4000="WHITE"),--('By-Name
Population'!E2:E4000="M"),--('By-Name Population'!F2:F4000="Jr NCO"))

But when I tried to replace the cell ranges with the names I defined:
=SUMPRODUCT(--(REDCAT="WHITE"),--(Gender="M"),--(Grade="Jr NCO"))

I get a #NUM error. Am I not using the Name correctly? I've even tried when
I'm using the formula to InsertNamePaste and it doesn't work. Is it because
the data is on another worksheet? I really need it to look at the entire
column because it could expand.

Thanks for the help!