Re: $$Excel-Macros$$ Sumif not working

Hi Thank you for the formula ,it is working well, Rajesh On Wednesday, December 26, 2012 11:24:08 AM UTC+5:30, Ms-Exl-Learner wrote: > > *In C16** cell* > =IF(ISNUMBER(B16),TEXT(B16,""),"") > *Drag it down.* > > *In D2 cell* > =SUMIF($C$16:$C$380,$B2,(D$16:D$380)) > *Drag it to right...* >

$$Excel-Macros$$ Re: Sumif not working

> and the mistake is the matching range is in date format and the criteria > is in Text format. > > Regards, > Lalit Mohan > +919711867226 > > > On Wednesday, 26 December 2012 11:24:19 UTC+5:30, kasper wrote: >> >> Hi Experts, >> >> In the attachment

$$Excel-Macros$$ Re: Sumif not working

nesday, December 26, 2012 11:24:19 AM UTC+5:30, kasper wrote: >> >> Hi Experts, >> >> In the attachment file the sumif formula is not working I don't know >> why.kindly point the mistakes in it. >> >> Regards >> >> Rajesh >> &g

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

mber 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 >> table format, How can use a formula with tw

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

ards, > 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, kasp

Re: $$Excel-Macros$$ Select sheet name in formula from the given table

Hi Ashish Thanks for the formula,I never use the indirect function before. Regards Rajesh On Sunday, December 30, 2012 1:35:16 PM UTC+5:30, ashish wrote: > > Try this > =SUMPRODUCT((INDIRECT("'"&C4&"'!B4:B8")=SUM!D2)*'01'!E4:E8) > > change your c4 value to '01 > > or change sheet names like

$$Excel-Macros$$ Re: Select Unique values

Hi Thanks for reply,I know about duplicate removeal but I am serching for a permanent formula . Regards Rajesh On Tuesday, January 1, 2013 9:23:20 PM UTC+5:30, Prince wrote: > > Hi Kasper, > > Dear instead of giving solution i just want to give the idea required to >

Re: $$Excel-Macros$$ Consolidate data from 31 sheets to one master sheet

Hi Paul Thanks for the idea you gave. Is there any way to add date criteria also there eg: 01/01/13 to 05/01/13 or 01/01/13 to 10/01/13. With regards and thanks Rajesh kainikkara On Tuesday, January 22, 2013 6:28:14 PM UTC+5:30, Paul Schreiner wrote: > > Because no two people have the same fi

Re: $$Excel-Macros$$ Consolidate data from 31 sheets to one master sheet

ood you can, > By all the means you can, > In all the ways you can, > In all the places you can, > At all the times you can, > To all the people you can, > As long as ever you can.” - John Wesley > *----- > > >

Re: $$Excel-Macros$$ For loop syntax for working same macro in all worksheets

Hi Paul Thanks for the code, even though my explanation is not so clear you give the right code for me. With regards & thanks Rajesh On Friday, February 8, 2013 5:59:19 PM UTC+5:30, Paul Schreiner wrote: > > What you've described is confusing. > But, let me explain how to loop through sheets

$$Excel-Macros$$ Re: use sumproduct formula to find min & max values

Hi Thanks for the formula, but the formula is not working for me. What is "with cse" Rgards Rajesh On Wednesday, October 30, 2013 5:08:00 PM UTC+5:30, kasper wrote: > > Hi Experts > > Please refer the attached document and tell me how can I get the min > and max