Lottery Grid - Total Numbers by Position

[ststern45]

I want to create a gird as follows:
Cell A1 = Number
Cells A2 through A40 = numbers 1 through 39
Cell B1 = P1 (Position 1)
Cell C1 = P1 (Position 2)
Cell D1 = P1 (Position 3)
Cell E1 = P1 (Position 4)
Cell F1 = P1 (Position 5)

Cell B2 = formula for counting how many times the number 1 appears in the 1st position of a 5/39 lottery game
Cell B3 = formula for counting how many times the number 2 appears in the 1st position of a 5/39 lottery game
Etc., etc.

Cell C3 = formula for counting how many times the number 2 appears in the 2nd position of a 5/39 lottery game

Thank you in advance!!

 

[ststern45]

I think I have the Position 1 correct.
B2 through B36

B2 formula = combin(38,4)
B3 formula = combin(37,4)

B36 formula = combin(4,1)
B37 through B40 would not contain any formulas

 

[Marcelo Branco]

Try

Combinações com posição.xlsx
	A	B	C	D	E	F
1		POSITION
2	#	1	2	3	4	5
3	1	73815
4	2	66045	7770
5	3	58905	14280	630
6	4	52360	19635	1785	35
7	5	46376	23936	3366	136	1
8	6	40920	27280	5280	330	5
9	7	35960	29760	7440	640	15
10	8	31465	31465	9765	1085	35
11	9	27405	32480	12180	1680	70
12	10	23751	32886	14616	2436	126
13	11	20475	32760	17010	3360	210
14	12	17550	32175	19305	4455	330
15	13	14950	31200	21450	5720	495
16	14	12650	29900	23400	7150	715
17	15	10626	28336	25116	8736	1001
18	16	8855	26565	26565	10465	1365
19	17	7315	24640	27720	12320	1820
20	18	5985	22610	28560	14280	2380
21	19	4845	20520	29070	16320	3060
22	20	3876	18411	29241	18411	3876
23	21	3060	16320	29070	20520	4845
24	22	2380	14280	28560	22610	5985
25	23	1820	12320	27720	24640	7315
26	24	1365	10465	26565	26565	8855
27	25	1001	8736	25116	28336	10626
28	26	715	7150	23400	29900	12650
29	27	495	5720	21450	31200	14950
30	28	330	4455	19305	32175	17550
31	29	210	3360	17010	32760	20475
32	30	126	2436	14616	32886	23751
33	31	70	1680	12180	32480	27405
34	32	35	1085	9765	31465	31465
35	33	15	640	7440	29760	35960
36	34	5	330	5280	27280	40920
37	35	1	136	3366	23936	46376
38	36		35	1785	19635	52360
39	37			630	14280	58905
40	38				7770	66045
41	39					73815
Plan2

Cell Formulas
Range	Formula
B3:F41	B3	=IF(OR(B$2>$A3,$A3>34+B$2),"",COMBIN($A3-1,B$2-1)*COMBIN(39-$A3,5-B$2))

M.

 

[ststern45]

Marcelo. Thank you so much.
Calculations are correct.
Genius!!

 

[Marcelo Branco]

You're welcome. Glad to help.

M.