how to use averageifs to calculate week to date averages

[dtrump]

i have dates in column A with corresponding performances in column C...i need help to create formula that will calculate the average of performances in column C ...using week to date criteria
thanks

 

[jorismoerings]

Hi,

Something like this:

Book1
	A	B	C	D
1	1-1-2018	1	10	11,67
2	2-1-2018	1	11	11,67
3	3-1-2018	1	12	11,67
4	4-1-2018	1	13	11,67
5	5-1-2018	1	14	11,67
6	6-1-2018	1	10	11,67
7	7-1-2018	2	15	17,86
8	8-1-2018	2	16	17,86
9	9-1-2018	2	17	17,86
10	10-1-2018	2	18	17,86
11	11-1-2018	2	20	17,86
12	12-1-2018	2	19	17,86
13	13-1-2018	2	20	17,86
14	14-1-2018	3	21	24,43
15	15-1-2018	3	22	24,43
16	16-1-2018	3	30	24,43
17	17-1-2018	3	23	24,43
18	18-1-2018	3	24	24,43
19	19-1-2018	3	25	24,43
20	20-1-2018	3	26	24,43
21	21-1-2018	4	40	30,80
22	22-1-2018	4	27	30,80
23	23-1-2018	4	28	30,80
24	24-1-2018	4	29	30,80
25	25-1-2018	4	30	30,80
Sheet1

Cell Formulas
Range	Formula
D1	=SUMPRODUCT((--(WEEKNUM($A$1:$A$25+0,1)=WEEKNUM(A1,1))*($C$1:$C$25)))/SUMPRODUCT(--(WEEKNUM($A$1:$A$25+0,1)=WEEKNUM(A1,1)))

 

[dtrump]

thanks for the help...for some reason i can't get the formula to calculate...below is the data i need to calculate...with the date in A, and the performance % in C..so whenever new information is entered for the day, i need a cell to show AVG performance % for the week to date

DATE	TOTAL POINTS	% SCORE
3/1/18	65	68%
3/2/18	50	52%
3/3/18	65	68%
3/4/18	72	75%
3/5/18	63	66%
3/6/18	60	63%
3/7/18	50	52%
3/8/18	58	60%
3/9/18	70	73%
3/10/18	80	83%
3/11/18	85	89%
3/12/18	74	77%
3/13/18	68	71%
3/14/18	55	57%
3/15/18	68	71%
3/16/18	85	89%
3/17/18	80	83%
3/18/18	75	78%
3/19/18	86	90%

<tbody>
</tbody><colgroup><col><col><col></colgroup>

 

[jorismoerings]

Here's my example https://app.box.com/s/pzn0rl1l9jmwyq7l0obit1gulpfrymx5