Thanx Bernd,

An xclent site recommendation, 4 sure!!! But! it is actually the code for
usage of conditional Sumproduct( ) that I require! Just want to know how can
I it! Any sample code would be tremendously helpful! If u could refer 2 me
such another sample for the usage of "sumproduct(--(xyz))"?

Thanx again pal!!!

"Bernd P" wrote:

Hello,

If I understand you correctly you need an AVERAGEIF function:
http://www.bettersolutions.com/excel...E725811811.htm

Regards,
Bernd