Re: $$Excel-Macros$$ V LOOKUP PROBLEM

2012-04-06 Thread Munir Ahmad
Dear Friends, Maries & Seraj... Thanks for u r help. Regards, Munnu. On 4/6/12, Seraj Alam wrote: > Hi, > > Try this one also.. > > =SUMPRODUCT(($C$2:$C$113=A2)*($D$2:$D$113)) > > On Thu, Apr 5, 2012 at 12:20 PM, Munir Ahmad > wrote: > >> Hi Group, >> >> please help >> >>

Re: $$Excel-Macros$$ V LOOKUP PROBLEM

2012-04-05 Thread Maries
No need Value formula, It can do it, =SUMIF($C$2:$C$113,A2,$D$2:$D$113) On Fri, Apr 6, 2012 at 12:51 AM, Maries wrote: > Hi, > > Try below formula, > > =SUMIF($C$2:$C$113,VALUE(A2),$D$2:$D$113) > > Regards, > > MARIES. > > > > On Thu, Apr 5, 2012 at 11:20 PM, Munir Ahmad wrote: > >> Hi Group,