Dear Sir Kindly see the attached sheet for the query you raised. I am not sure whether this what you were looking for. I may have used the longer route. Kindly enlighten me. With regards
Bye
N.SHIVKUMAR
Mobile : +919866533180
Office : +914027685310
Res. : +914040035774
Alternate Email: shiv1...@yahoo.com
On 12 February 2010 09:20, Ayush <jainayus...@gmail.com> wrote:
> THANKS Aindril. But In Sumifs function it is not possible to have two
> criteria(of = sign) on same range.
>
> Any example would help.
>
> The formula =sumifs("A:A","B:B","=12","B:B","=C") does not seems to be
> working.
>
> Regards,
> Ayush Jain
>
> On Feb 11, 8:37 am, Aindril De <aind...@gmail.com> wrote:
> > Hi Ayush,
> >
> > If you are using Exel 2007 then you can use Sumifs function, or otherwise
> > you can use sumproduct function if you are using any version below 2007.
> >
> > Regards,
> > Aindril
> >
> > On Wed, Feb 10, 2010 at 9:30 PM, Ayush <jainayus...@gmail.com> wrote:
> > > Dear Group,
> >
> > > I have a query on sumif function that if I would like to sum a range
> > > based on two values of other range.
> >
> > > For example :
> >
> > > Column A = Amount
> > > Column B = Product Line(12,15,CM,AS,AR,AJ etc.)
> >
> > > I want to sum column A if Column B = 12 or CM or AJ
> >
> > > the below is not working :
> >
> > > =sumif(A:A,B:B,"12,CM,AJ")
> >
> > > Any Help ?
> >
> > > The compounding of three sumif like = sumif(.....) + sumif(....) +
> > > sumif(....) is not I am looking for.
> >
> > > Thanks for advising.
> >
> > > Best regards,
> > > Ayush Jain
> >
> > > --
> >
> > >
> ----------------------------------------------------------------------------------
> > > Some important links for excel users:
> > > 1. Follow us on TWITTER for tips tricks and links :
> > >http://twitter.com/exceldailytip
> > > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> > >http://www.excelitems.com
> > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > > 5. Excel Tips and Tricks athttp://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
> > > <><><><><><><><><><><><><><><><><><><><><><>
> > > HELP US GROW !!
> >
> > > We reach over 6,700 subscribers worldwide and receive many nice notes
> about
> > > the learning and support from the group.Let friends and co-workers know
> they
> > > can subscribe to group at
> > >http://groups.google.com/group/excel-macros/subscribe
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. 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
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,700 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. 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
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,700 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Solution by N Shivkumar.xls
Description: MS-Excel spreadsheet
