Have formulas increase "incrementally" per column

[mark91345]

I am trying to find the frequency of lottery numbers that occur within 10-day periods (see row 7).
Instead of having to manually write each formula for each column, is there a way I can automate it, so that each column will "advance" 10 days?

Excel 2012
	A	B	C	D	E	F	G	H
1	ct	0	1	2	3	4	5	6
2	date_am	5/30/2013	5/29/2013	5/28/2013	5/27/2013	5/26/2013	5/25/2013	5/24/2013
3	N1	3	3	4	7	4	0	5
4	N2	1	3	2	2	6	6	0
5	N3	2	3	8	9	9	6	8
6
7	ball	d10	d20	d30	d40	d50	d60	d70
8	0	1	2
9	1	1	2
10	2	0	1
11	3	2	2
12	4	2	0
13	5	2	1
14	6	0	2
15	7	2	0
16	8	0	0
17	9	0	0
18
19	sum	10	10
am

 

[ukmikeb]

HI

If you could show the formulae for cells B9 and C9 it would help us to help you.

 

[mark91345]

My apologies. I thought that they would show using HtmlMaker.
Actually, I am not exactly sure how to display the formulae.
Is there an add-on that does this, or do I need to hand-type them?

HI

If you could show the formulae for cells B9 and C9 it would help us to help you.

 

[ukmikeb]

Hi

HTMLMaker should have displayed them if you used the default option.

As it's only two cells could you copy and paste?