Hi there,

I'm trying to do an averageifs formula that appears for each entry in column T of my spreadsheet. So for the averageifs in cell T2, I need a formula that takes the average of values in column E over observations whose entry in column G matches that of cell R2 and whose entry in column A is different from H2. I can't get the 'does not equal H2' part of the formula to work when I copy the averageifs formula down column T. The code:

=AVERAGEIFS(E:E,G:G, R2,A:A, <>H2 )

doesn't work and I don't know why. Putting inverted commas makes every averageifs check that entries taken into the average do not have a value in a equal to H2, but I want that check to be does not equal Hx for each row x I apply the formula in T to.

Your help would be dearly appreaciated!