xl2007 add columns 6789 thru 10302
 

I have a task to sum all values in the columns 6789 through 10302. I'd like
to assign a range name to at leat one of the columns and have that name
appear in the formula bar, but this is not happening in xl 2007.
Hopefully, going forward I won't have a need to sum columns 4613 through
10302.

xl2007 add columns 6789 thru 10302
 

What name are you using?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Jimmy" wrote in message
...
I have a task to sum all values in the columns 6789 through 10302. I'd
like to assign a range name to at leat one of the columns and have that
name appear in the formula bar, but this is not happening in xl 2007.
Hopefully, going forward I won't have a need to sum columns 4613 through
10302.

xl2007 add columns 6789 thru 10302
 

I figured it out. Instead of =SUM(JAC:OFF) I used
=SUM(JAC:JAC,colmycolumn). I renamed column OFF to colmycolumn. Keep in
mind that there is nothing wrong with JAC:OFF, but a few co-workers of mine
are immature and have a juvenile sense of humour and were mocking my
formula. Being the clever one, I exhibited the perspicacity to take
remedial action and change the formula so it would be less of a distraction.




"Bob Phillips" wrote in message
...
What name are you using?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Jimmy" wrote in message
...
I have a task to sum all values in the columns 6789 through 10302. I'd
like to assign a range name to at leat one of the columns and have that
name appear in the formula bar, but this is not happening in xl 2007.
Hopefully, going forward I won't have a need to sum columns 4613 through
10302.

xl2007 add columns 6789 thru 10302
 

But =SUM(JAC:JAC,colmycolumn) is not the same as =SUM(JAC:OFF), you need
=SUM(JAC:OFE,colmycolumn) to get the same result.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Jimmy" wrote in message
...
I figured it out. Instead of =SUM(JAC:OFF) I used
=SUM(JAC:JAC,colmycolumn). I renamed column OFF to colmycolumn. Keep in
mind that there is nothing wrong with JAC:OFF, but a few co-workers of mine
are immature and have a juvenile sense of humour and were mocking my
formula. Being the clever one, I exhibited the perspicacity to take
remedial action and change the formula so it would be less of a
distraction.




"Bob Phillips" wrote in message
...
What name are you using?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Jimmy" wrote in message
...
I have a task to sum all values in the columns 6789 through 10302. I'd
like to assign a range name to at leat one of the columns and have that
name appear in the formula bar, but this is not happening in xl 2007.
Hopefully, going forward I won't have a need to sum columns 4613 through
10302.