Hey Guys,

Ran into another annoying problem that doesn't seem to difficult in theory but i can't figure it out;

http://imgur.com/a/kLv1Z

So what i'm trying to do is get the average of cells N:N IF cells D:D correspond with C1. I know a doozy right.

I've mucked around with count functions, if functions and just can't seem to get it to work.

My line of thinking with how the cell will sort of look is; =average(index(N:N,match((countif(D:D,indirect("c1"))......
The more i think about it the less it makes sense so hopefully one of you guys can help me figure this out as it seems like a super simple problem but i just can't get it.

Thanks Guys

Ed