Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding "letters (column headings)"
Anyone know how to do this? Here is what I mean:
I have about 40 columns across the page that will have data summed up in row 49. I need the totals in row 49 put into a separate chart for calculations. (i.e. Column C will have numbers in 1-48 totaled in row 49. Same thing for all columns from C to BZ) I want to add the column letters, not the numbers, and that is where I have the problem. I have the fomula to read "=C49", so that my total in C49 is pulled to where I want it for further calculations. Then in the next row below needs to read "=D49" and then "=E49" and so on, so that all the column totals are now in one column from top to bottom. How do I get fill down/fill series to add the column letters? When I use fill down, it starts going C49, then C50, then C51, which is NOT what i want it to do. I need it to read =C49, the D49, ext to BZ49. I also have a more complex formula "=ROUND(C49*C5*24,2)", which will be using the totals I have moved over, and when I use fill down with it, it adds the numbers as well, so it goes to "=ROUND(C50*C6*24,2)" instead of "=ROUND(D49*D6*24,2)". How do get the letters to "increase" but not the numbers? I suspect I will have to put a $ in front of the numbers, but I have no idea what to do with the letters. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automating adding up a column | Excel Worksheet Functions | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
match and count words | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |