Average with month condition

[Paywand]

Dear all,

there is a column, contains a lot of percentage and beside it has a lot of date which equal to percentage column.

i want to average all percentage which beside date if equal "January"

thanks,

 

[gaz_chops]

Sorry the result was not correct, previously i have used this formula for counting H what equal to January in G

=SUMPRODUCT(--(H3:H1000<>"");--(MONTH(G3:G1000)=1))

but now i need that for the averaging which locate H3:H1000 and equal to January in G.

Both formulas Aladins & mine work, Aladin's is the better option, just adjust the ranges to suit your data and replace , with ;

 

[Paywand]

---------------------
------------------------------------

 

[Paywand]

Does post #2 say nothing to you?

E2 houses January.

Now invoke:

=AVERAGEIFS(B:B,G:G,">="&(1&E2)+0,B:B,"<="&EOMONTH(1&E2,0))

which is fast.

sorry sir, but its not clear for me

 

[Aladin Akyurek]

sorry sir, but its not clear for me

What is not clear? Did you try it at all? If you did, what happens?

 

[Paywand]

What is not clear? Did you try it at all? If you did, what happens?

i have adjusted the formula like this

=AVERAGEIFS(G5:G100;H5:H100;">="&(1&E2)+0;G5:G100;"<="&EOMONTH(1&E2;0))

and the result is #DIV/0!

 

[Aladin Akyurek]

i have adjusted the formula like this

=AVERAGEIFS(G5:G100;H5:H100;">="&(1&E2)+0;G5:G100;"<="&EOMONTH(1&E2;0))

and the result is #DIV/0!

Do you also have January in E2?

 

[Paywand]

Do you also have January in E2?

yes i have it, if you could upload me an workbook with those formula, i will be thankful.

 

[Aladin Akyurek]

yes i have it, if you could upload me an workbook with those formula, i will be thankful.

E2: January (a month name)

=AVERAGEIFS(G5:G100;H5:H100;">="&(1&E2)+0;H5:H100;"<="&EOMONTH(1&E2;0))

 

[Paywand]

E2: January (a month name)

=AVERAGEIFS(G5:G100;H5:H100;">="&(1&E2)+0;H5:H100;"<="&EOMONTH(1&E2;0))

thanks a lot its worked.

 

[Aladin Akyurek]

thanks a lot its worked.

You are welcome.