If you're using xl2007, then you can use the entire column.

If you're using xl2003 or below, then you can't.

Maybe you can use all the rows but one.

or maybe you can use a dynamic range that changes with the amount of data.

Debra Dalgleish explains dynamic range names he
http://contextures.com/xlNames01.html#Dynamic

SFC Traver wrote:

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!

--

Dave Peterson