Calculating Average # of Procedures per Week

[onecodevee01]

What would be the easiest way to calculate the average # of procedures per week in the data set in the below screenshot? I would prefer that it be calculated via a Pivot Table but a formula in an additional column will work as well.
(note: each row is 1 procedure, so in this data set shown there are 44 procedures, and I have entered a formula in column C to pull in the week number based on the date in column B and week starting on a Monday.)

 

[myall_blues]

One way would be to make a list of unique week numbers in another column (say column D), then in column E have a COUNTIFS formula as

=COUNTIFS(C$2:C$24,D2)

Adjust ranges to suit.

Book1
	C	D	E
1	Week
2	22	22	7
3	22	23	12
4	22	24	4
5	22
6	22
7	22
8	22
9	23
10	23
11	23
12	23
13	23
14	23
15	23
16	23
17	23
18	23
19	23
20	23
21	24
22	24
23	24
24	24
Sheet3

Cell Formulas
Range	Formula
E2:E4	E2	=COUNTIFS(C$2:C$24,D2)

 

[RobP]

Indeed, as myall_blues said, maybe a helper column can get you the desired result like thus in cell G1 :

Book1
	A	B	C	D	E	F	G	H	I	J	K
1			22		4		4		Total no of weeks = 6
2			22		4				Total no of Procs = 24
3			22		4
4			22		4
5			23		5
6			23		5
7			23		5
8			23		5
9			23		5
10			24		2
11			24		2
12			25		4
13			25		4
14			25		4
15			25		4
16			26		8
17			26		8
18			26		8
19			26		8
20			26		8
21			26		8
22			26		8
23			26		8
24			27		1
25
Sheet1

Cell Formulas
Range	Formula
E1:E24	E1	=COUNTIF(C1:C24,C1:C24)
G1	G1	=SUMPRODUCT(E1:E24,1/COUNTIF(C1:C24,C1:C24))/SUM(IF(FREQUENCY(C1:C24,C1:C24)>0,1))
Dynamic array formulas.