Hi Abdul

Try
=SUM(INDEX(A:A,C1):INDEX(A:A,C2))
with your starting row number in C1 and you ending row number in C2
--
Regards
Roger Govier

"abdul" wrote in message
...
I am trying to sum a column with the sum function say : sum(a1:a12)
however I don't always want it to add row 1 to row 12

depending on an inputted number I want to add a3 to a12, or a5 to a12,
or
somthing like that
is there a way I can make the sum function do that or is there any other
way
to sum up a column from row x to row 12 or something like that