Hi All,
Any updates from the below mail.
i am looking another sum formula in to this sumproduct, In cell consolidated
report sheet Cell F4. just add another sum formula in to this sumproduct
based on names. the data is in contain deleted sheet.
regards
lokesh.M
On Thu, Jan 5, 2012 at 6:39 PM, Ra
Use this :
=SUM((Sheet2!$G$2:$G$65536=UPPER(LEFT(D4,1)&MID(D4,FIND("
",D4,1)+1,LEN(D4)-FIND(" ",D4,1)+1)))*Sheet2!$D$2:$D$65536)
Regards
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of lokesh
Sent: Jan/Thu/2012 08:23
To: excel-macros@googlegr