Average If...

Originally Posted by Kevin UK

How about you have a go. I think ever one has given you enough info!

I've been on this bit for over an hour. I'll keep trying but if anyone has any advice I'd appreciate it.

Thanks.

Got it.

Didn't know I could use AverageIf in 2003 so had to use an array.

D17=AVERAGE(IF(B6:B8=B12:B14,D6:D8))

Thanks again for the first bit I would never have got that.

Ryan