Thread: INDEX
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
stumped stumped is offline
external usenet poster
 
Posts: 37
Default 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