naming columns (not row specific)

[dwojtowi]

Is it possible to name a column, without naming the indivudual rows
then reference the column name adding a row number

I would want to name columns a:d as January, then in a different shee
reference different rows withing the group january

for example
(If(Count(January9)=0,"",sum(Jan9))
(If(Count(January10)=0,"",sum(Jan10))

This would then do the count and sum of the january columns for row
and 10 respectively!
Thanks,
Dav

 

[Bernie Deitrick]

Dave,

If your named range January includes a header row, then you can use

=SUM(OFFSET(January,9,0,1,4))

Where the 9 can be a cell reference...

HTH,
Bernie
MS Excel MVP