Great Ankur SirExcellent
On Sun, Jun 24, 2018 at 12:02 AM, ankur wrote:
> hi amar takale
>
> *Solution is attached as per your requirement ,i have not used sumproduct*
>
> *May this file help you*
>
>
>
>
>
> *With Regards:*
>
> *CMA** Ankur Pandey*
> *B.Com (H), C.M.A *
> * Mob: :-
-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar
*Sent:* Friday, September 13, 2013 4:21 PM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ SumProduct
Hi,
I have a problem with Sumproduct function please find attached file
, 2013 4:21 PM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ SumProduct
Hi,
I have a problem with Sumproduct function please find attached file for
the same where from E1, F1 G1 are condtions based on it I need sum up
Column D.
Thanks in advance.
Regards
Hi MLT,
Try using below formula which need to be confirmed using key combination:
ctrl shift enter
=IF(ISNUMBER(MATCH(A5,MID($A$1:$A$3,MIN(IFERROR(SEARCH($A$4,$A$1:$A$3),))+2,1)*1,0)),Matching,NotMatching)
Regards,
DILIPandey
On Tue, Jan 14, 2014 at 6:10 PM, MLT mlthorn...@gmail.com wrote:
I'm looking for some help with one of the components of a SUMPRODUCT
formula that is causing the formula to error:
Starting in A1:
alpha137
beta224
gamma492
in A4: 49
in A5: 2
The idea is for one of the components of the SUMPRODUCT formula to look for
a string (in A4) in each cell in the
:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar
*Sent:* Friday, September 13, 2013 4:21 PM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ SumProduct
** **
Hi,
I have a problem with Sumproduct function please
Ur welcome
Warm Regards,
Ravi Kumar.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Chandra Shekar
Sent: Monday, September 16, 2013 12:27 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ SumProduct
Hello,
Thanks its
Hi,
I have a problem with Sumproduct function please find attached file for the
same where from E1, F1 G1 are condtions based on it I need sum up Column
D.
Thanks in advance.
Regards,
Chandra
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) !
@googlegroups.com
Subject: $$Excel-Macros$$ SumProduct
Hi,
I have a problem with Sumproduct function please find attached file for the
same where from E1, F1 G1 are condtions based on it I need sum up Column
D.
Thanks in advance.
Regards,
Chandra
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT
hi
To insert sumproduct formula thru VBA you by using evaluate.
Pl refer http://www.xldynamic.com/source/xld.SUMPRODUCT.html
HTH//Cheers
On Fri, Jul 12, 2013 at 7:17 PM, Chandra Shekar
chandrashekarb@gmail.com wrote:
Hi,
Could you please let me know how to use sumproduct using VBA?
Hi,
Could you please let me know what your are asking for?
Thanks in advance.
Regards,
Chandra
On Sat, Jul 13, 2013 at 7:23 AM, Bé Trần Văn betnmtdongna...@gmail.comwrote:
With VBA require you to download the file
2013/7/12 Chandra Shekar chandrashekarb@gmail.com
Hi,
Could you
Hi,
Could you please let me know how to use sumproduct using VBA? Where range
is date values.
=SUMPRODUCT(--(INT(Dump!$F$2:$F$5)=C2)*(INT(Dump!$F$2:$F$5)=D2)*--((Dump!$D$2:$D$5=U)+(Dump!$D$2:$D$5=E)0))
Regards
Chandra
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do
With VBA require you to download the file
2013/7/12 Chandra Shekar chandrashekarb@gmail.com
Hi,
Could you please let me know how to use sumproduct using VBA? Where range
is date values.
Hi,
Could you please help me in the attached file instruction is there in it.
Thanks in advance.
Regards,
Chandra
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
=SUMPRODUCT(N($C$2:$C$11=E5),N($B$2:$B$11=A)) with cse
On Tue, Jul 2, 2013 at 6:51 AM, Chandra Shekar chandrashekarb@gmail.com
wrote:
Hi,
Could you please help me in the attached file instruction is there in it.
Thanks in advance.
Regards,
Chandra
--
Are you =EXP(E:RT) or
Hi,
Am getting a wrong count as 2 I have changed the E5 with date.
Regard,
Chandra
On Tue, Jul 2, 2013 at 7:30 PM, priti verma pritiverma1...@gmail.comwrote:
=SUMPRODUCT(N($C$2:$C$11=E5),N($B$2:$B$11=A)) with cse
On Tue, Jul 2, 2013 at 6:51 AM, Chandra Shekar
=SUMPRODUCT(N(DATE(YEAR(C2:C11),MONTH(C2:C11),DAY(C2:C11))=DATE(2013,8,2)),N($B$2:$B$11=A))
with CSE
On Tue, Jul 2, 2013 at 7:27 AM, Chandra Shekar chandrashekarb@gmail.com
wrote:
Hi,
Am getting a wrong count as 2 I have changed the E5 with date.
Regard,
Chandra
On Tue, Jul 2,
Try using SUM with CSE
=SUM((C2:C11C3)+((C2:C11C3)*(B2:B11=A)))
Or SUMPRODUCT
=SUMPRODUCT((C2:C11C3)+((C2:C11C3)*(B2:B11=A)))
Rgds,
[dp]
Pada 02/07/2013 20:51, Chandra Shekar menulis:
Hi,
Could you please help me in the attached file instruction is there in it.
Thanks in advance.
Regards,
Dear All,
Sumproduct function return the Max function output but Not a Min fuction
Output .
for example
I got output when i use max function but when i try to get output for min
value out put is Zero.
=SUMPRODUCT(MAX(($E$6:$E$20=E6)*($F$6:$F$20))) E column is Region and F
column is Amount
Dear Amar,
You are getting a #Value error.. since you have the following #Value errors
in your data.
ASTRAZENECA PHARMA INDIA LTD 36 #VALUE! PFIZER LIMITED 35 17.6 SUN
PHARMA ADVANCED RESEARCH 33 #VALUE!
On Fri, Jan 11, 2013 at 12:15 PM, amar takale amartak...@gmail.com wrote:
Hi All,
No problem hide row delete,no matter.
On Fri, Jan 11, 2013 at 1:59 PM, Aindril De aind...@gmail.com wrote:
Dear Amar,
You are getting a #Value error.. since you have the following #Value
errors in your data.
ASTRAZENECA PHARMA INDIA LTD 36 #VALUE! PFIZER LIMITED 35 17.6 SUN
PHARMA
If you Delete the rows mentioned.. then the formula you have mentioned works
On Fri, Jan 11, 2013 at 2:09 PM, amar takale amartak...@gmail.com wrote:
No problem hide row delete,no matter.
On Fri, Jan 11, 2013 at 1:59 PM, Aindril De aind...@gmail.com wrote:
Dear Amar,
You are getting a
edit the formula in cells D163 and below and add =IFERROR(AX8/V8,0) . add
If error in all to avoid value errors
Or try this
=SUM(IF(ISNUMBER($C$163:$C$182+$D$163:$D$182),$C$163:$C$182*$D$163:$D$182,0))/C183
with Ctrl+shift+ Enter
or
Visit this link
C the attached file. ? u r missing.
From: Kuldeep Singh naukrikuld...@gmail.com
To: excel-macros@googlegroups.com
Sent: Monday, August 6, 2012 12:44 PM
Subject: Re: $$Excel-Macros$$ Sumproduct function to get sum between two date
Dear Lakshman,
Require
-macros@googlegroups.com
*Sent:* Monday, August 6, 2012 12:44 PM
*Subject:* Re: $$Excel-Macros$$ Sumproduct function to get sum between
two date
Dear Lakshman,
Require output value 4625000 your formula is not working.
It's working fine. =SUMPRODUCT((A7:A24=E1)*(A7:A24=F1)*(F7:F24))
Regards
ok
From: LAKSHMAN PRASAD lakshman_...@yahoo.com
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Sent: Tuesday, August 7, 2012 11:53 AM
Subject: Re: $$Excel-Macros$$ Sumproduct function to get sum between two date
C the attached file. ? u r
-macros@googlegroups.com
Sent: Saturday, August 4, 2012 4:02 PM
Subject: $$Excel-Macros$$ Sumproduct function to get sum between two date
Dear experts,
I need output of sum between two date by using of Sumproduct as below formula
but the error is occur in fuction, please see attache sheet
: http://www.gaursonsindia.com/
--
*From:* Ashish Bhalara ashishbhalar...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Saturday, August 4, 2012 4:02 PM
*Subject:* $$Excel-Macros$$ Sumproduct function to get sum between two
date
Dear experts,
I need
Dear experts,
I need output of sum between two date by using of Sumproduct as below
formula but the error is occur in fuction, please see attache sheet.
=SUMPRODUCT(A7:A23E1)*(A7:A23F1)*(F7:F23)
Thanks regards.
Ashish Bhalara
9624111822
P*Please do not print this email unless it is
=SUMPRODUCT((A7:A23=E1)*(A7:A23=F1)*(F7:F23))
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Ashish Bhalara
Sent: 04 August 2012 4:02
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros
@googlegroups.com
*Subject:* $$Excel-Macros$$ Sumproduct function to get sum between two
date
** **
Dear experts,
** **
I need output of sum between two date by using of Sumproduct as below
formula but the error is occur in fuction, please see attache sheet.
** **
=SUMPRODUCT
Friends help me on this help.
Thanks
N.Sundarvelan
9600160150
-- Forwarded message --
From: Sundarvelan N nsund...@gmail.com
Date: Fri, Mar 2, 2012 at 11:52 AM
Subject: $$Excel-Macros$$ Sumproduct accross multiple sheets
To: excel-macros@googlegroups.com
Hi Friends,
Help me
Hi,
Assume the sheet name always be in dd-mmm-yy format. I have define a name
CurrPeriod, you need to define it on your file. Just change Start End
Date reference in this formula. I also change some Locations for SALES in
multiple sheets to make sure it works :-)
See the attached.
Hi Friends,
Help me in achieving this task.
sumproduct across multiple sheets
Thanks
N.Sundarvelan
9600160150
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code
Dear group,
I have got an excel file getting sales volume of different customers in
buying different services on a daily basis. I want to use sumproduct
formula to get the sales volume buying services on a monthly basis.
However, the desired results are not found. Please help.
--
Darwin Chan
Dear Darwin,
Please see attached sheet. Hope it will help you..
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Fri, Dec 9, 2011 at 8:03 AM, Darwin
Thanks Noorain,
I got the problem solved!!
2011/12/9 NOORAIN ANSARI noorain.ans...@gmail.com
Dear Darwin,
Please see attached sheet. Hope it will help you..
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
: $$Excel-Macros$$ Sumproduct using VBA
Hello,
Could you please let me know whats the error in using sumproduct function in
below code. I am getting error number 2015
Is there any other way to use sumproduct function using vba with multiple
condtions.
Thanks in advance.
Sub ABNAMROAdd
Hello,
Could you please let me know whats the error in using sumproduct function in
below code. I am getting error number 2015
Is there any other way to use sumproduct function using vba with multiple
condtions.
Thanks in advance.
Sub ABNAMROAdd()
Dim compnm As String
lastcl =
Hi Noorain,
It works. Thanks a lot for your support
On Tue, Aug 9, 2011 at 12:13 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Peer Mohd,
Please see attached sheet
On Tue, Aug 9, 2011 at 11:46 AM, Shiek Peer Mohd shiekp...@gmail.comwrote:
Hi Experts,
I have
try
$F$4581=Lost)+(Data!$F$2:$F$4581=
From: Shiek Peer Mohd
Sent: Tuesday, August 09, 2011 1:16 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ sumproduct issue
Hi Experts,
I have the issues in using the multiple criteria in sumproduct. Sample file
attached.
Regards
Hi
U have consider G1 = 2527 in pivot table not in sumproduct sheet. Please
check
Thanks
Mahesh
On Fri, Jul 15, 2011 at 6:20 PM, Pascal Baro bpascal...@googlemail.comwrote:
Hi,
This time there really is a difference between the pivot table and
productsum function.
It seems it's all
thanks Mahesh,
btw, I guess it would be better to use getpivotdata function instead
of a sumproduct function that requires the entire excel application to
update data if any modification to the data or the function is made...
thanks again
On 15 juil, 15:08, Mahesh parab mahes...@gmail.com wrote:
Hi,
Why is sumproduct returning a value greater thant a pivot table on the
same data range ? Is it about the number of rows (over 30,000)?
I'd like to be more specific but maybe I can post the file in this
group, if someone can tell me how.
Regards,
Thanks
--
Hi Ashish koul,
I have seen many of your replies and it mostly contains Sumproduct formula. i
checked this formula in Microsoft Help (MS Help) and it seems very easy thing.
but what you use in your answer is very much different than what is given in
the
MS help.
could u please explain why and
From: Dave Bonallack davebonall...@hotmail.com
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Sent: Thu, August 5, 2010 4:53:35 AM
Subject: RE: $$Excel-Macros$$ Sumproduct with 3 criteria +
Hi Nadine,
Sorry I haven't got back to you on this. And I don't even know
This seems to be missing your text, Kumar. :(
From: Kumar Punnam mr.ravikumar@gmail.com
To: excel-macros@googlegroups.com
Sent: Thu, August 5, 2010 6:29:35 AM
Subject: Re: $$Excel-Macros$$ Sumproduct with 3 criteria +
On Tue, Aug 3, 2010 at 5:54 PM
of the SumProduct formula x 2
Is that it?
Also, can you tell me the name of the sheet where the SumProduct actually
resides?
Regards - Dave.
Date: Mon, 2 Aug 2010 09:51:34 -0700
From: n8dine4ma...@yahoo.com
Subject: $$Excel-Macros$$ Sumproduct with 3 criteria +
To: excel-macros@googlegroups.com
-macros@googlegroups.com excel-macros@googlegroups.com
Sent: Tue, August 3, 2010 2:40:30 AM
Subject: RE: $$Excel-Macros$$ Sumproduct with 3 criteria +
Hi Nadine,
I'm guessing a bit.
What I need is a total of the result of that
I assume this means the result of your SumProduct formula
plus the same
I have a workbook that needs a sumproduct.
I have:
=SUMPRODUCT(('Sheet3'!$A$2:$A$1000='Summary'!$F2)*('Sheet3'!$B$2:$B$1000='Summary'!$G2)*('Sheet3'!$C$2:$C$1000='Summary'!$H2)*('Sheet3'!$AD$2:$AD$1000='Summary'!R$4),('Sheet3'!$AB$2:$AB$1000))
What I need is a total of the result of that plus
Hi Jai,
Sum product formula will give you sum of product of two columns or arrays.
For ex:
Check the following table :
A B C
Product QtyPrice / unit
A 2 45
B 5 50
C 10 35
D
Chk it,,
Multiplies all the components of the two arrays and then adds the products —
On Wed, Apr 21, 2010 at 10:10 AM, Jai jaihumtu...@gmail.com wrote:
Dear All, Can you tell me that what is the work of sum product.
--
Thanks For Mail.
--
Dear All, Can you tell me that what is the work of sum product.
--
Thanks For Mail.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
Hello,
I have enclosed the copy of xl sheet, hope which will clarify your
question. If you need any clarification or If am wrong please let me know.
Thanks Regards
--
Vinu
(¨`*.*´¨) Always
`*.¸(¨`*.*´¨) Keep
(¨`*.*´¨)¸.*´ Smiling!
`*.¸.*´
54 matches
Mail list logo