View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul Paul is offline
external usenet poster
 
Posts: 661
Default Can I make array position A(12) into a variable A(12*n) ?

I am constantly adding data to my array and want formulas that can expand
with the data. Data is added by weeks. The first number is at A1 how can I
put in a formula that it needs to sum A1, A12,A24,depending on the week? Such
as A(1*n) where n is the week number.

Thanks....Paul