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

[exceltechconsulta...@gmail.com]

On Jun 2, 6:39 am, Jay <kishan....@gmail.com> 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 <dilipan...@gmail.com> 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 
> > <nidhe...@rediffmail.com>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
>
> > > <http://sigads.rediff.com/RealMedia/ads/click_nx.ads/www.rediffmail.co...>
>
> >  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
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---