pssureshbabu
New Member
- Joined
- Oct 5, 2006
- Messages
- 16
Hello all!
I notice my AutoFill option do like this:
=SUM(A1:A5)
After dragging down using autofill, the result is
=SUM(A2:A6)
=SUM(A3:A7)
is it possible to program autofill to do the following?
=SUM(A6:A10)
=SUM(A11:A15)
and so on...
thanks for your help,
Babu
I notice my AutoFill option do like this:
=SUM(A1:A5)
After dragging down using autofill, the result is
=SUM(A2:A6)
=SUM(A3:A7)
is it possible to program autofill to do the following?
=SUM(A6:A10)
=SUM(A11:A15)
and so on...
thanks for your help,
Babu