Calculate average() up to a certain cell

[seyss]

Hello,

I want to use the PROCV or other function to help me calculate the average of some numbers in a column up to a month defined in another cell.

Example:

jan/21	09
feb/21	28
mar/21	62
apr/21	88

I'd have a cell indicating the current month, example:

Cell A1 = mar/21

I need to calculate the average of those numbers up to the month in cell A1 (mar/21); it'd return average(9,28,62) = 33.
If I change A1 to apr/21, it'd return average(9,28,62,88) = 46.75

Any tips?

Thanks!

 

[KOKOSEK]

Could you update your details about information what version of Excel are you using? It helps to help You.

 

[seyss]

Sorry, it's Office 365 latest version

 

[KOKOSEK]

BTW: put this as 'Office version' in your account details.
If these data: jan/21 , feb/21 etc. a real date formatted to display mm/yy or it is a text looks like date?

 

[seyss]

It is a real date

 

[KOKOSEK]

Book1
	A	B	C	D	E
1	Apr-21	46.75		Jan-21	9
2				Feb-21	28
3				Mar-21	62
4				Apr-21	88
Sheet9

Cell Formulas
Range	Formula
B1	B1	=AVERAGEIFS(E:E,D:D,"<="&A1)

 

[seyss]

Thank you very much!!