Hi Mike,

Thank you so much for the reply..

"Mike H" wrote:

Hi,

For Sumproduct have a look he-

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

and for help on array formula

http://www.cpearson.com/excel/ArrayFormulas.aspx

Mike

"Srikanth" wrote:

Hi,

Can any one explain me what is sum product and how does it works...
And also the array....

Thanks in advance...