Pegasus3245
New member
- Joined
- Nov 17, 2012
- Messages
- 1
- Reaction score
- 0
- Points
- 0
Hi All,
Really struggling with a simple seqence. I have 4 years of sales data, I want to display these as a weekly total for each week. All my daily sales are in 1 colum.
I want to have:-
b1 =sum(a1:a7)
b2 = sum(a8:a14)
b3 = sum(a15:a21)
and continuing....
when i use the sequence dragger thingie mabob down it simply incriments each row so instead of getting b4 = sum(a22:a28), im getting b4 =sum(a16:a22).
Im pretty sure this is a simple vba string then drag it down, but i cannot find the solution anywhere; all i can find is complex codes for dragging down text and number strings being incrimented by a specific character or a specific number etc.
Any help would be greatly apreciated.
Thanks in advance.
Really struggling with a simple seqence. I have 4 years of sales data, I want to display these as a weekly total for each week. All my daily sales are in 1 colum.
I want to have:-
b1 =sum(a1:a7)
b2 = sum(a8:a14)
b3 = sum(a15:a21)
and continuing....
when i use the sequence dragger thingie mabob down it simply incriments each row so instead of getting b4 = sum(a22:a28), im getting b4 =sum(a16:a22).
Im pretty sure this is a simple vba string then drag it down, but i cannot find the solution anywhere; all i can find is complex codes for dragging down text and number strings being incrimented by a specific character or a specific number etc.
Any help would be greatly apreciated.
Thanks in advance.