Re: $$Excel-Macros$$ Vlookup with total

2012-10-27 Thread Suman
Hi Amit, All solution are great and we can also use below mentioned function for for the same: =SUMIF(A2:A8,"a",B2:B8) =SUM(SUMIF(A2:A8,{"a","b","c"},B2:B8)) *Suman Kumar* On Tue, Oct 23, 2012 at 12:56 PM, Amit Desai (MERU) wrote: > Dear All, > > ** ** > > I have an excel file f

RE: $$Excel-Macros$$ Vlookup with total

2012-10-23 Thread Amit Desai (MERU)
Thanks a lot. Best Regards, Amit From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: 23 October 2012 13:19 To: excel-macros@googlegroups.com Cc: gawlianil8...@gmail.com Subject: Re: $$Excel-Macros$$ Vlookup with total Dear Amit, Please

Re: $$Excel-Macros$$ Vlookup with total

2012-10-23 Thread NOORAIN ANSARI
> > Best Regards, > > Amit > > ** ** > > *From:* अनिल नारायण गवली [mailto:gawlianil8...@gmail.com] > *Sent:* 23 October 2012 12:59 > *To:* excel-macros@googlegroups.com; Amit Desai (MERU) > *Subject:* Re: $$Excel-Macros$$ Vlookup with total > > ** ** >

Re: $$Excel-Macros$$ Vlookup with total

2012-10-23 Thread Aamir Shahzad
roups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI > *Sent:* 23 October 2012 13:07 > *To:* excel-macros@googlegroups.com > > *Subject:* Re: $$Excel-Macros$$ Vlookup with total > > ** ** > > Dear Amit, > > I think SUMPRODUCT will better tha

RE: $$Excel-Macros$$ Vlookup with total

2012-10-23 Thread Amit Desai (MERU)
Pls share sum-product formula... Best Regards, Amit From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: 23 October 2012 13:07 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Vlookup with total Dear Amit, I think

Re: $$Excel-Macros$$ Vlookup with total

2012-10-23 Thread Aamir Shahzad
** ** > > *From:* अनिल नारायण गवली [mailto:gawlianil8...@gmail.com] > *Sent:* 23 October 2012 12:59 > *To:* excel-macros@googlegroups.com; Amit Desai (MERU) > *Subject:* Re: $$Excel-Macros$$ Vlookup with total > > ** ** > > kindly share a sample file with groups,, &g

RE: $$Excel-Macros$$ Vlookup with total

2012-10-23 Thread Amit Desai (MERU)
Please find attached sample data file... I need Vlookup solution & not the Pivoting pls... Best Regards, Amit From: अनिल नारायण गवली [mailto:gawlianil8...@gmail.com] Sent: 23 October 2012 12:59 To: excel-macros@googlegroups.com; Amit Desai (MERU) Subject: Re: $$Excel-Macros$$ Vlookup with t

Re: $$Excel-Macros$$ Vlookup with total

2012-10-23 Thread NOORAIN ANSARI
Dear Amit, I think SUMPRODUCT will better than Vlookup. Pls share sample sheet for better clarity On Tue, Oct 23, 2012 at 12:56 PM, Amit Desai (MERU) wrote: > Dear All, > > ** ** > > I have an excel file for which, there is Incentive worked out based on 2-3 > parameters for the same Techni

Re: $$Excel-Macros$$ Vlookup with total

2012-10-23 Thread अनिल नारायण गवली
kindly share a sample file with groups,, Regards, Gawli Anil On Tue, Oct 23, 2012 at 12:56 PM, Amit Desai (MERU) wrote: > Dear All, > > ** ** > > I have an excel file for which, there is Incentive worked out based on 2-3 > parameters for the same Technician. > > ** ** > > I want to do a

$$Excel-Macros$$ Vlookup with total

2012-10-23 Thread Amit Desai (MERU)
Dear All, I have an excel file for which, there is Incentive worked out based on 2-3 parameters for the same Technician. I want to do a vlookup with the total amount (of 2-3 amounts) against that person. Please help me with a formula. Best Regards, Amit Discl