Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
INDEX
This formula =SUM(D4:INDEX(D:D,ROW()-1)) is not allowing me to edit
anything within the entire column due to this formula ="Cumulative Amount Pledged @ "&TEXT(AA2,"MM/dd/yy"). I just would like to add 20 rows to the data prior to the summation. Please advise |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
INDEX
You need to spell this out in more detail. Where is the SUM formula, where
is the other formula? What is 'not allowing' - expand. Do you mean the answers is wrong if you do something? best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Stumped" wrote in message ... This formula =SUM(D4:INDEX(D:D,ROW()-1)) is not allowing me to edit anything within the entire column due to this formula ="Cumulative Amount Pledged @ "&TEXT(AA2,"MM/dd/yy"). I just would like to add 20 rows to the data prior to the summation. Please advise |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart axes color index vs font color index | Charts and Charting in Excel | |||
How do I pull the col. index value as well as row index value | Excel Discussion (Misc queries) | |||
index/index | Excel Worksheet Functions | |||
INDEX | Excel Worksheet Functions | |||
Using Index(A:A,.........) | Excel Worksheet Functions |