xl2007 add columns 6789 thru 10302

  • Thread starter Thread starter Jimmy
  • Start date Start date
J

Jimmy

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.
 
What name are you using?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
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.
 
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)
 
Back
Top