Hello zoher , Why you want to apply formula in this way?
You can write the values in a1, b1, c1 and put formula in d1 then copy the formula of d1 in d2, d3, d4 and so on... Hope it will help, On 1/9/12, Phen Varghese <phenvargh...@gmail.com> wrote: > Didn't understand your question PLS be more specific on your question > then only I or someone else available can help. > > RGDS, > > Phen > > On 1/9/12, zoher <zos...@gmail.com> wrote: >> hello membres, >> i have a query regarding formula. example, i have entered a formula in >> cell >> b1 as follows >> =sum(a1:a3) >> now i coppyed this formula and pested in b2, >> in b2, it will appier like =sum(a2:a4)but i want it as =sum(a4:a6) >> as in b1 the cell range was a1:a3 so i want in b2 to continue the range as >> a4:a6. >> and in b3 a7:a9 and so on >> please help me >> >> Search for old postings at: >> http://www.mail-archive.com/accessindia@accessindia.org.in/ >> >> To unsubscribe send a message to >> accessindia-requ...@accessindia.org.in >> with the subject unsubscribe. >> >> To change your subscription to digest mode or make any other changes, >> please >> visit the list home page at >> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >> >> > > > Search for old postings at: > http://www.mail-archive.com/accessindia@accessindia.org.in/ > > To unsubscribe send a message to > accessindia-requ...@accessindia.org.in > with the subject unsubscribe. > > To change your subscription to digest mode or make any other changes, please > visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > -- The greatest pleasure in life is doing what people say you cannot do. Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
