7;!B4),(Sheet2!D2:D65536))+IFERROR(VLOOKUP(C4,Range,2,0),0)
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Lokesh Loki
> *Sent:* Jan/Sun/2012 07:52
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-
2012 07:52
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Add counts in sumproduct
Hi All,
Please find the attached excel file. And I need to add counts in
consolidated report sheet based on names which is already given in "deleted
report" sheet", In consolidated repo
