If-Then Excel Logic question

Hello,

I am new to this forum and I apologize if this is a question that has previously been submitted. Here is the breakdown of what I would like to accomplish:

1. What I have: There are three columns. The first is a list of student names (sometimes repeated dependent on the third). The second is a list of corresponding class names they are registered in (also repeated dependent on the third column). The third is a list of attendance records by day.

2. What I would like to do: I wish to write a general formula that identifies that if both the row cells in column 1 (Names) are the same AND the row cells in column 2 (Class) are the same, then the numbers in column (3) need to averaged for those matched rows.

I've included an example set that may help visualize what I'm trying to do. So as an example, the formula would identify Drake, Janie from the first column AND Math 101 from the second column and then average the corresponding values (5/5 = 1). The formula would identify Drake, Janie from the first column AND Chem 101 from the second column and then average the corresponding values (2/5 = 0.4). Etc.

Thanks ahead for your help.

Yes it does. Thank you. But how can do it for a list for 6000 entries? When I try to amend the formula you've provided for any length greater than 100, it won't let me and defaults to 100.

e.g. I have this: =IF(A2&B2=A1&B1,"",AVERAGEIFS($C$2:$C$100,$A$2:$A$100,A2,$B$2:$B$100,B2))

but if I try this: =IF(A2&B2=A1&B1,"",AVERAGEIFS($C$2:$C$6000,$A$2:$A$6000,A2,$B$2:$B$6000,B2)), it will default to the above.

Is there just a way to make the formula work for an infinite list? That would take care of my problem too. Thanks again.

You're correct. Now it works. I obviously made a mistake somewhere. Thanks for your and sktneer's help!