Still not clear, however, I suspect that the functions AVERAGEIF & AVERAGEIFS may be what you're after - see XL Help for more info. on these and their practical application.

(note however neither is backwards compatible with earlier versions should this be a concern)