See the below web site ..
http://www.exceluser.com/explore/sumproduct_12.htm
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ankur
Sent: Tuesday, July 05, 2011 11:18 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Request for
*hi sant ram
plz check links below
for sumproduct
http://chandoo.org/wp/2009/11/10/excel-sumproduct-formula/
for array formulas
http://www.cpearson.com/excel/ArrayFormulas.aspx
for substitute
http://www.excelitems.com/2010/05/substitute-function.html
*Have A Nice Time & Enjoy Life
Regards:
