$$Excel-Macros$$ Re: Solver

2009-06-02 Thread exceltechconsulta...@gmail.com 

You are not clear with your question and your vba code is also
protected

On May 31, 4:58 am, H Upadhyay  wrote:
> Dear All,
>
> pls go through the attached file.
>
> here i m passing row no, is there any way with out passing any row no it
> solve entire for entire column
>
> Regards
> Harish Upadhyay
> 9773284902
>
>  King.xls
> 42KViewDownload

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: SUMIF for multiple conditions

2009-06-02 Thread exceltechconsulta...@gmail.com 



On Jun 2, 6:39 am, Jay  wrote:
> Hi,
>
> You can use sumproduct formula as below :
>
> =SUMPRODUCT(--(A4:A8>=100),--(A4:A8<=300),(B4:B8))
>
> it's give the same result ...
>
> On Jun 1, 7:52 pm, Dilip Pandey  wrote:
>
>
>
> > Hi Nidhesh,
>
> > Excellent criteria.
> > I have attached one file which can be of interest for you.
>
> > Note:- If you need some more examples, then please let me know.
>
> > Thanks
> > --
> > DILIP KUMAR PANDEY
> >   MBA-HR,B COM(Hons.),BCA
> > Mobile: +91 9810929744
> > dilipan...@gmail.com
> > dilipan...@yahoo.com
> > New Delhi - 110062
> > On Fri, May 29, 2009 at 2:27 PM, Nidhesh Dhawan 
> > wrote:
>
> > > Hi,
>
> > > Can any body help me with applying sumif formulae with multiple 
> > > conditions.
>
> > > I have following reservations:
>
> > > 1) Don't want to use Array formulae.
> > > 2) Don't wat to use DSUM.
> > > 3) Dont want to apply concatenate.
>
> > > Please send me an example if possible.
>
> > > Thanks,
> > > Nidhesh
>
> > > 
>
> >  SumIf-Multiple Critieria.xls
> > 18KViewDownload- Hide quoted text -
>
> > - Show quoted text -- Hide quoted text -
>
> - Show quoted text -

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: SUMIF for multiple conditions

2009-06-02 Thread exceltechconsulta...@gmail.com 

Hi Jay,

What does this "--" double dash do in this formula.

Thanks
Exceltech

On Jun 2, 6:39 am, Jay  wrote:
> Hi,
>
> You can use sumproduct formula as below :
>
> =SUMPRODUCT(--(A4:A8>=100),--(A4:A8<=300),(B4:B8))
>
> it's give the same result ...
>
> On Jun 1, 7:52 pm, Dilip Pandey  wrote:
>
>
>
> > Hi Nidhesh,
>
> > Excellent criteria.
> > I have attached one file which can be of interest for you.
>
> > Note:- If you need some more examples, then please let me know.
>
> > Thanks
> > --
> > DILIP KUMAR PANDEY
> >   MBA-HR,B COM(Hons.),BCA
> > Mobile: +91 9810929744
> > dilipan...@gmail.com
> > dilipan...@yahoo.com
> > New Delhi - 110062
> > On Fri, May 29, 2009 at 2:27 PM, Nidhesh Dhawan 
> > wrote:
>
> > > Hi,
>
> > > Can any body help me with applying sumif formulae with multiple 
> > > conditions.
>
> > > I have following reservations:
>
> > > 1) Don't want to use Array formulae.
> > > 2) Don't wat to use DSUM.
> > > 3) Dont want to apply concatenate.
>
> > > Please send me an example if possible.
>
> > > Thanks,
> > > Nidhesh
>
> > > 
>
> >  SumIf-Multiple Critieria.xls
> > 18KViewDownload- Hide quoted text -
>
> > - Show quoted text -- Hide quoted text -
>
> - Show quoted text -

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---