Averageif funtion to find average of multiple rows

[pavifish]

Hi,
Hopefully, someone can help me. I am new to Excel. For example, trying to find the average of the games drawn by teams C, D, E & F. Consider there are 100 teams, and I know the names of the teams needing to find the average. However, I can not use the formula above and need to use the =AVERAGEIF formula. Is there any way to do that? Please help if you can. Thank you.

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H
1
2	A			10		17		C
3	B			19				D
4	C			21				E
5	D			13				F
6	E			22
7	F			12
8	G			13
9	H			11
Data

Cell Formulas
Range	Formula
F2	F2	=AVERAGE(FILTER(D2:D9,COUNTIFS(H2:H5,A2:A9)))

 

[pavifish]

Hi & welcome to MrExcel.
How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H
1
2	A			10		17		C
3	B			19				D
4	C			21				E
5	D			13				F
6	E			22
7	F			12
8	G			13
9	H			11
Data

Cell Formulas
Range	Formula
F2	F2	=AVERAGE(FILTER(D2:D9,COUNTIFS(H2:H5,A2:A9)))

Hi, Thank you very much for your help. However the formula works perfectly with the sample sheet but whenevr I try to use it on my actual worksheet the result comes different. I am guessing I am messing up somewhere. So trying to fix. Hopefully will be sorted. Thanks again

 

[Fluff]

In that case please post a representative sample of your data.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Averageif funtion to find average of multiple rows
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[pavifish]

Hi,
Just found out me Error. It's solved. Thank you very much.

 

[pavifish]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Averageif funtion to find average of multiple rows
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Sorry, didn't know. Thanks.

 

[Fluff]

It's solved. Thank you very much.

You're welcome & thanks for the feedback.