ut, hey, it's a solution. :) Maybe
someone else will have an idea that's easier to use.
From: Paul Schreiner
To: excel-macros@googlegroups.com
Sent: Tue, August 24, 2010 12:07:33 PM
Subject: Re: $$Excel-Macros$$ Urgent: SUMIF +
it might be a probl
several
cells,
or use a VBA function to handle the calculations!
Paul
From: None
To: excel-macros@googlegroups.com
Sent: Tue, August 24, 2010 1:45:31 PM
Subject: Re: $$Excel-Macros$$ Urgent: SUMIF +
Can this work having about 21 SUMIF formulas in one cell
No problem.
It's not an "elegant" solution, but it works.
VBA would be better (and more fun)
Paul
From: None
To: excel-macros@googlegroups.com
Sent: Tue, August 24, 2010 1:26:55 PM
Subject: Re: $$Excel-Macros$$ Urgent: SUMIF +
Paul: Than
Can this work having about 21 SUMIF formulas in one cell?
From: None
To: excel-macros@googlegroups.com
Sent: Tue, August 24, 2010 10:26:55 AM
Subject: Re: $$Excel-Macros$$ Urgent: SUMIF +
Paul: Thank you! Your "a" solution works and I'm s
of 567891,
yet you included them in your calculation.
this isn't the best way... I'd probably write it as VBA and loop through...
hope this helps,
Paul
From: None
To: excel-macros@googlegroups.com
Sent: Tue, August 24, 2010 10:50:51 AM
Subject: $
ed them in your calculation.
this isn't the best way... I'd probably write it as VBA and loop through...
hope this helps,
Paul
From: None
To: excel-macros@googlegroups.com
Sent: Tue, August 24, 2010 10:50:51 AM
Subject: $$Excel-Macros$$ Urgent: SUMIF
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
11 matches
Mail list logo