Re: $$Excel-Macros$$ Help reqd for using SUMIF along with a variable (month)

2010-06-30 Thread saggi
Hi! Parag, What Exactly output u want its not clear"I want that I can count the no.of dispathces I done in 3july for old date.". Saggi realsa...@gmail.com On Jun 30, 4:27 pm, parag dafal wrote: > Dear Sir, >             Please help me in the formula for countif & other. i want to > count the n

Re: $$Excel-Macros$$ Help reqd for using SUMIF along with a variable (month)

2010-06-30 Thread anand kunchukuttan
Hi Chitra, I'm from Pune and looking, for a good Job in Pune only. Where is Pushpa Vihar located? If You recruit for Pune I will forward you my updated resume. Regards, Anand.

Re: $$Excel-Macros$$ Help reqd for using SUMIF along with a variable (month)

2010-06-30 Thread Radhe Sham
Hi all once again Thanks for all the responses but the solution is not as simple as it seems i suppose While making 2 summaries, one with sumif and the other with a lookup fulfills the required criteria to some extent, its not the solution being looked for ( Because data is updated at different i

Re: $$Excel-Macros$$ Help reqd for using SUMIF along with a variable (month)

2010-06-30 Thread GAURAV JAIN
Hi Radhe, PFA the attached solution Regards, Gaurav Jain On Wed, Jun 30, 2010 at 2:54 PM, Radhe Sham wrote: > Hi Andy, > > Thanks for the quick reply. > > The requirement however is to get the output in another sheet wherein the > summary of the products is mentioned in the first column and t

Re: $$Excel-Macros$$ Help reqd for using SUMIF along with a variable (month)

2010-06-30 Thread carrierbpo Bpo industry
Dear Freinds, I am Chitra from Recruitment Pro.. We are a Hr Consultant Based in G.K 2. Right now i want a MIS- Asst Manager for Citi Designation- Asst Manager Company - Citi Financial (In the payroll of Jra & Associate) Location - Pushpa Vihar Salary - Between 12 k to 15 k Please refer some nam

Re: $$Excel-Macros$$ Help reqd for using SUMIF along with a variable (month)

2010-06-30 Thread Radhe Sham
Hi Andy, Thanks for the quick reply. The requirement however is to get the output in another sheet wherein the summary of the products is mentioned in the first column and the desired month is placed on the top as a dropdown list. The result is required to be displayed in the 2nd column for whic

Re: $$Excel-Macros$$ Help reqd for using SUMIF along with a variable (month)

2010-06-30 Thread Aindril De
Hi Radhe, PFA the attached solution Regards, Andy On Wed, Jun 30, 2010 at 12:44 PM, Radhe Sham wrote: > Hi Group > > I have data which has repeated values for a set of product every month for > 12 months > > Need the output as total for each product ( sumif formula helps here) > > But the requ

$$Excel-Macros$$ Help reqd for using SUMIF along with a variable (month)

2010-06-30 Thread Radhe Sham
Hi Group I have data which has repeated values for a set of product every month for 12 months Need the output as total for each product ( sumif formula helps here) But the requirement is, in the summary if the month is changed, then the output has to be the sum total for each product for the res