Re: $$Excel-Macros$$ Re: Need sumif formula with 2 conditions

2012-12-30 Thread Prince
Hi Harmeet, PFA. Regards Prince On Sunday, December 30, 2012 12:39:38 PM UTC+5:30, harneetsingh2808 wrote: > > Hi experts > > I need a macro to run countif on an unknown range, the countif should run > on the entire Column B till the time value in any cell of Column B becomes > Null. > > Thank

Re: $$Excel-Macros$$ Re: Need sumif formula with 2 conditions

2012-12-29 Thread harneet singh
Hi experts I need a macro to run countif on an unknown range, the countif should run on the entire Column B till the time value in any cell of Column B becomes Null. Thanks Harneet > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use c

Re: $$Excel-Macros$$ Re: Need sumif formula with 2 conditions

2012-12-29 Thread kasper
Hi Sorry for my mistake, How ever I solve my issue using sumproduct formula. Regards Rajesh On Thursday, December 27, 2012 9:54:33 AM UTC+5:30, अनिल नारायण गवली wrote: > > Dear Rajesh , > > Pl attach the right workbook . Your attached workboon contains no data. > > Regards, > Gawli Anil >

$$Excel-Macros$$ Re: Need sumif formula with 2 conditions

2012-12-29 Thread kasper
Hi Prince Sorry for my mistake, How ever I solve my issue using sumproduct formula. Regards Rajesh On Wednesday, December 26, 2012 9:17:45 PM UTC+5:30, Prince wrote: > > Hi Rajesh, > > There is no data in the sheet. > :( > > regards > Prince > > On Wednesday, December 26, 2012 5:28:24 PM UTC+5:

Re: $$Excel-Macros$$ Re: Need sumif formula with 2 conditions

2012-12-26 Thread अनिल नारायण गवली
Dear Rajesh , Pl attach the right workbook . Your attached workboon contains no data. Regards, Gawli Anil On Wed, Dec 26, 2012 at 9:17 PM, Prince wrote: > Hi Rajesh, > > There is no data in the sheet. > :( > > regards > Prince > > On Wednesday, December 26, 2012 5:28:24 PM UTC+5:30, kasper wr

$$Excel-Macros$$ Re: Need sumif formula with 2 conditions

2012-12-26 Thread Prince
Hi Rajesh, There is no data in the sheet. :( regards Prince On Wednesday, December 26, 2012 5:28:24 PM UTC+5:30, kasper wrote: > > Hi experts, > > Please check the attached file.In it the first table contains daily > purchase data, I want to get a summery report of the same in the second > tab