Creating averages per user based off contained text in other cell

[aspofford]

Hi,
This is a copy of some data from pivot tables that list users, their courses and their current course grade averages.

example.xlsx
	A	B	C
1			Averages
2	User 1
3	Art and World Cultures A	66%	73%
4	Art and World Cultures B	80%
5	Consumer Math A	75%	61%
6	Consumer Math B	47%
7	English 12 A	76%	71%
8	English 12 B	66%
9	Forensic Science 1	91%	91%
10	Health, Safety and Nutrition	#DIV/0!	N/A
11	USA Test Prep	63%	63%
12	User 2
13	Consumer Math A	84%
14	Consumer Math B	51%
15	English 12 A	91%
16	English 12 B	65%
17	High School ELD	56%
18	Personal Finance	56%
19	Physical Science A	92%
20	Physical Science B	60%
21	USA Test Prep	33%
22	User 3
23	Algebra 2 A	89%
24	Algebra 2 B	83%
25	AP English Literature & Composition A	74%
26	AP English Literature & Composition B	57%
27	Environmental Science A	96%
28	Environmental Science B	98%
29	USA Test Prep	77%
30	User 4
31	Algebra with Finance B	94%
32	Honors Chemistry A	83%
33	Honors Chemistry B	94%
34	Honors English 12 A	90%
35	Honors English 12 B	69%
36	Personal Finance	93%
37	USA Test Prep	100%
Sheet1

I need to average percentages for each user only if they are in Part A and Part B of the same course. The other courses keep their current averages. I entered example averages on in the last column for the 1st user as an example.

There are 4,000+ users and their course names differ per user. Does anyone have an idea on how to best to calculate the averages for Part A and Part B for each course for each user?
Please let me know if you need further information.

 

[COwen]

If I understand correctly, you only want to average the values of parts A and B if both A and B contain averages? If this is the case, then enter the following formula:

=IF(OR(A1="",B1=""""),"",AVERAGE(A1:B1))