Average a range while omitting a row because of a certain criteria

Here is the problem
i am doing a report card and i need to average column c if column b and column a match or dont match

a b c
name grade score

pat 7 100
fred 7 90
tom 7 80
mike 7 95
luke 6 100
joe 6 90
larry 6 85
sue 5 95
tom 5 93


how do i write the formula to average grade seven and omit pat to get my class average (without pat)

the report card cell for the class averge is "H5" (the formula would go here)
the name to omit is in cell "H6"
the grade the student is in is in "H7"

=averageifs(C3:C11,B3:B11,H7,A3:A11,"<>H6") this does not work!!

what am i doing wrong

please help!!!

You have the cell range for H6 inside the double quotes. It must be outside the quotes like this:

=AVERAGEIFS(C3:C11,B3:B11,H7,A3:A11,"<>"&H6)

You were VERY close

Originally Posted by RudiS

You have the cell range for H6 inside the double quotes. It must be outside the quotes like this:

=AVERAGEIFS(C3:C11,B3:B11,H7,A3:A11,"<>"&H6)

You were VERY close

this is still not working
all im trying to do is averaging all grades in class 7 omitting pat
because i want the averages of the other students in the class

name grade score
pat 7 100
fred 7 90 92.5?????
tom 7 80 pat
mike 7 95 7
luke 6 100
joe 6 90
larry 6 85
sue 5 95
tom 5 93


how do i write the formula to average grade seven and omit pat to get my class average (without pat)

the report card cell for the class averge is "H5" (the formula would go here)
the name to omit is in cell "H6"
the grade the student is in is in "H7"

See the attached workbook. As far as I can see, it is accurate.

AverageIF.xlsx

you are correct! thanks it works on this sheet

but now im trying to make it work in a workbook with multiple pages
which means transferring data from page 1 to page 2
how can i send this workbook here so you can help me here
can i attach it somehow and bring it in here?
im new at this

You can upload your file to the post you create.
To do this, first click on the button called: Go Advanced on the bottom right corner where you reply to this post.
When the advanced post window opens, type your message and then click the button I indicate in the attached image.
When you have browse and loaded the image, you can add it to your message using the Add Inline button or from the attachment dropdown.

1.jpg

2.jpg

Ok i works

i was trying to do it on a different worksheet
i could not make that work but if i do it on the same one that the
info is on i can make it work
than i just link the cell

maybe i should have used the insert array function or something to do it all in one cell

dont know how

thank you so much

Excellent...

Here is an example over two sheets

AverageIF2.xlsx

Hey it works!!
thanks so much for your help

you saved the day!!!!