View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Abdul Abdul is offline
external usenet poster
 
Posts: 35
Default sum a column with a variable

i want to sum up a column say from a1 to a12 which i s not too difficult. the
problem is that i sometimes want to sum up a3 to a12 or a5 to a12 depending
on what number has been entered. is there a way to make the function
sum(a1:a12) add different number of rows. is there any other way to do that.
could the number 1 in a1 be a variable somehow? abdul