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.
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 wrote:
> Hi Ayush,
>
> If you are
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 wrote:
> Dear Group,
>
> I have a query on sumif function that if I would like to
Hi Ayush,
Not sure about SumIf, but we can use SumProduct:
=SUMPRODUCT((A1:A1000)*((B1:B1000="AJ")+(B1:B1000="CM")+(B1:B1000=12)))
Note that SumProduct doesn't seem to support using whole column refs.
Regards - Dave.
> Date: Wed, 10 Feb 2010 07:30:38 -0800
> S
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,"1
