Hi,

Every month I have to do the tasks of summing of few records and I have to change array according to line, is there any function in excel by which I can automate this manual changing of array work without using macro, I mean, as and when I paste the data above the total line the total should pick the entire above column..

Like this month I put a sum of column H1 to H30 and next month if i will be having a data on coluimn h1 to h44 than it would onlly gives me a result of sum of column h1 to h30 but actually i should get the sum of column H1:H44.. .