Average ONLY for current days in month

[redspanna]

Hi all

I'm sure there is a simple answer to this but can't seem to figure it out.
I simply just need a formula to give the AVERAGE of Sales values stored thru C2:C32, but ONLY up until the current day of the month.

NDA.xlsm
	B	C
1	DAY	SALES
2	1	70
3	2	0
4	3	545
5	4	4695
6	5	0
7	6	140
8	7	70
9	8	0
10	9	950
11	10	70
12	11	820
13	12	0
14	13	0
15	14	0
16	15	0
17	16	0
18	17	0
19	18	0
20	19	0
21	20	0
22	21	0
23	22	0
24	23	0
25	24	0
26	25	0
27	26	0
28	27	0
29	28	0
30	29	0
31	30	0
32	31	0
33	AVERAGE	237
34		669
35
Sheet2

Cell Formulas
Range	Formula
C2:C32	C2	=SUMIFS(Data!$F$2:$F$8000,Data!$A$2:$A$8000,DATE(YEAR(TODAY()),MONTH(TODAY()),B2))
C33	C33	=AVERAGE(C2:C32)
C34	C34	=AVERAGE(C2:C12)

So in the example if today was day 11 then the average I would like returned would be the AVERAGE OF C2:C12 thus giving the return of 669
If I use the =AVERAGE(C2:C32) formula , the return is 237

Thanks in advance for any help

 

[AlanY]

try this

=AVERAGEIF(B2:B32,"<="&DAY(TODAY()),C2:C32)

 

[redspanna]

try this

=AVERAGEIF(B2:B32,"<="&DAY(TODAY()),C2:C32)

Perfect - thanks a lot

 

[AlanY]

you're welcome