Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Max row Height in XL2007 | Excel Discussion (Misc queries) | |||
There's no export to dbf files from XL2007? | Excel Discussion (Misc queries) | |||
XL2007 vs XL203 speed | Excel Discussion (Misc queries) | |||
XL2007 Copy As Picture | Excel Discussion (Misc queries) | |||
HOW DO I CHANGE THE FORMAT OF A SS# FROM 123-45-6789 TO 123456789 | Excel Worksheet Functions |