Thread: Indirect Sum
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Micki Micki is offline
external usenet poster
 
Posts: 38
Default Indirect Sum

I want to sum a row of values but the columns will vary each month. The start
point of each row will always be column V, but the ending column will expand
by one column each month. I have entered the formula
=SUM(INDIRECT("v11:"&$B$2&"11")), which works, but I need to copy this down
to many rows. How can I write it so the row numbers will increase by 1 as I
copy down to subsequent rows so that it reads to sum v12, v13 etc.