Re: $$Excel-Macros$$ Add counts in sumproduct

2012-01-09 Thread Lokesh Loki
Hi Rajan, This formula is not capturing correct counts. regards lokesh.M On Mon, Jan 9, 2012 at 8:33 PM, Rajan_Verma wrote: > Use this in F4 > > Range = J2:J21 in DeleteReport sheet > > ** ** > > =SUMPRODUCT(--(Sheet2!G2:G65536='consolidated > report'!B4),(Sheet2!D2:D65536))+IFERROR(VLO

RE: $$Excel-Macros$$ Add counts in sumproduct

2012-01-09 Thread Rajan_Verma
Use this in F4 Range = J2:J21 in DeleteReport sheet =SUMPRODUCT(--(Sheet2!G2:G65536='consolidated report'!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