Re: $$Excel-Macros$$ Sumproduct Multiple Criteria formula

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: :- +9

Re: $$Excel-Macros$$ SumProduct

It converts values in Boolean (TRUE or FALSE, 1 or 0) which are enclosed in bracket after "--". On Tue, Sep 23, 2014 at 10:40 AM, SUDHIR VERMA wrote: > Dear Ravi, > what is use of "--" before B2:B13 in above formula. > > Please explain. > > > > On 13 September 2013 16:28, Ravi Kumar wrote: > >>

Re: $$Excel-Macros$$ SumProduct

Dear Ravi, what is use of "--" before B2:B13 in above formula. Please explain. On 13 September 2013 16:28, Ravi Kumar wrote: > Hi, > > > > Try this.. > > > > =SUMPRODUCT((E1=A2:A13)*(--B2:B13=F1)*(C2:C13=G1)*(D2:D13)) > > > > > > > > *Warm Regards,* > > *Ravi Kumar.* > > > > *From:* excel-mac

Re: $$Excel-Macros$$ SUMPRODUCT: #VALUE ERROR

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 wrote: > I'm looking f

RE: $$Excel-Macros$$ SumProduct

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

Re: $$Excel-Macros$$ SumProduct

Hello, Thanks its working fine.. On Fri, Sep 13, 2013 at 4:28 PM, Ravi Kumar wrote: > Hi, > > ** ** > > Try this.. > > ** ** > > =SUMPRODUCT((E1=A2:A13)*(--B2:B13=F1)*(C2:C13=G1)*(D2:D13)) > > ** ** > > ** ** > > * * > > *Warm Regards,* > > *Ravi Kumar.* > > ** ** > > *From:* excel-

RE: $$Excel-Macros$$ SumProduct

Hi, Try this.. =SUMPRODUCT((E1=A2:A13)*(--B2:B13=F1)*(C2:C13=G1)*(D2:D13)) Warm Regards, Ravi Kumar. From: 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.c

Re: $$Excel-Macros$$ Sumproduct using VBA

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 VB

Re: $$Excel-Macros$$ 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 wrote: > With VBA require you to download the file > > 2013/7/12 Chandra Shekar > >> Hi, >> >> Could you please let me know how to use sumproduct using

Re: $$Excel-Macros$$ Sumproduct using VBA

With VBA require you to download the file 2013/7/12 Chandra Shekar > 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

Re: $$Excel-Macros$$ Sumproduct help

Hi All, Thanks its working fine. Regards, Chandra On Tue, Jul 2, 2013 at 8:51 PM, De Premor wrote: > Try using SUM with CSE > > =SUM((C2:C11>C3)+((C2:C11>C3)*(B2:B11="A"))) > > Or SUMPRODUCT > =SUMPRODUCT((C2:C11>C3)+((C2:C11>C3)*(B2:B11="A"))) > > Rgds, > [dp] > > Pada 02/07/2013 20:51, Chan

Re: $$Excel-Macros$$ Sumproduct help

Try using SUM with CSE =SUM((C2:C11>C3)+((C2:C11>C3)*(B2:B11="A"))) Or SUMPRODUCT =SUMPRODUCT((C2:C11>C3)+((C2:C11>C3)*(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. Rega

Re: $$Excel-Macros$$ Sumproduct help

=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 wrote: > 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, prit

Re: $$Excel-Macros$$ Sumproduct help

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 wrote: > =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: > >> H

Re: $$Excel-Macros$$ Sumproduct help

=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 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 =NOT(EXP(E:RT)) in E

Re: $$Excel-Macros$$ Sumproduct Formula Required

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 http://www.mrexcel.com/forum/excel-questions/2

Re: $$Excel-Macros$$ Sumproduct Formula Required

If you Delete the rows mentioned.. then the formula you have mentioned works On Fri, Jan 11, 2013 at 2:09 PM, amar takale wrote: > No problem hide row delete,no matter. > > > On Fri, Jan 11, 2013 at 1:59 PM, Aindril De wrote: > >> Dear Amar, >> >> You are getting a #Value error.. since you have

Re: $$Excel-Macros$$ Sumproduct Formula Required

No problem hide row delete,no matter. On Fri, Jan 11, 2013 at 1:59 PM, Aindril De 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 ADVANCED RES

Re: $$Excel-Macros$$ Sumproduct Formula Required

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 wrote: > Hi All, > Pls suggest me Sumpro

Re: $$Excel-Macros$$ Sumproduct function to get sum between two date

ok From: LAKSHMAN PRASAD To: "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

Re: $$Excel-Macros$$ Sumproduct function to get sum between two date

egroups.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&g

Re: $$Excel-Macros$$ Sumproduct function to get sum between two date

C the attached file. ? u r missing. From: Kuldeep Singh 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 output value 4625000

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, Kuldeep Singh Phone.: +91-120-4763789, Extn.: 789 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print

Re: $$Excel-Macros$$ Sumproduct function to get sum between two date

Thanks to all, I make very silly mistake. On Mon, Aug 6, 2012 at 12:29 PM, LAKSHMAN PRASAD wrote: > You are missing > > > SUMPRODUCT((A7:A23>E1)*(A7:A23 > > *Lakshman Prasad* > Manager (Finance) > GAURSONS INDIA LIMITED > Ph: +91 12 456777 Mob. No. 9582279261 > Website: http://www.gaursonsindia.c

Re: $$Excel-Macros$$ Sumproduct function to get sum between two date

You are missing  SUMPRODUCT((A7:A23>E1)*(A7:A23http://www.gaursonsindia.com/ From: Ashish Bhalara 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 expert

Re: $$Excel-Macros$$ Sumproduct function to get sum between two date

Hi Ashish, Please see attachment. Regards, Kuldeep Singh Phone.: +91-120-4763789, Extn.: 789 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Sat, Aug 4, 2012 at 4:19 PM, Rajan_Verma wrote: > *=SUMPRODUCT

RE: $$Excel-Macros$$ Sumproduct function to get sum between two date

=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$$ Su

Re: $$Excel-Macros$$ Sumproduct accross multiple sheets

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. _

Re: $$Excel-Macros$$ Sumproduct for multiple criteria lookup

Thanks Noorain, I got the problem solved!! 2011/12/9 NOORAIN ANSARI > > Dear Darwin, > > Please see attached sheet. Hope it will help you.. > > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/* > *http://noorain-ansari.

Re: $$Excel-Macros$$ Sumproduct for multiple criteria lookup

Dear Darwin, Please see attached sheet. Hope it will help you.. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Fri, Dec 9, 2011 at 8:03 AM, Darwi

RE: $$Excel-Macros$$ Sumproduct using VBA

Hello, Use : a = "SUMPRODUCT(--(" & rng1 & "=""" & "BEL" & """),--(" & rng2 & "=""" & "AAO" & """),--(" & rng4 & "))" HTH Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Chandra Shekar Envoyé : lundi 29 août 2011 16:37 À : excel-mac

Re: $$Excel-Macros$$ sumproduct issue

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, Sh

Re: $$Excel-Macros$$ sumproduct issue

Hi Noorain, It works. Thanks a lot for your support On Tue, Aug 9, 2011 at 12:13 PM, NOORAIN ANSARI wrote: > Dear Peer Mohd, > > Please see attached sheet > > On Tue, Aug 9, 2011 at 11:46 AM, Shiek Peer Mohd wrote: > >> >> Hi Experts, >> >> I have the issues in using the multipl

Re: $$Excel-Macros$$ sumproduct and pivot table on same data ranges - different results - (part 2)

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 wrote: > Hi > > U have co

Re: $$Excel-Macros$$ sumproduct and pivot table on same data ranges - different results - (part 2)

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 wrote: > Hi, > > This time there really is a difference between the pivot table and > productsum function. > It seems it's all about decimal values. Pr

Re: $$Excel-Macros$$ Sumproduct with 3 criteria +

This seems to be missing your text, Kumar.  :( From: Kumar Punnam 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, Nadine S wrote: Let me try

Re: $$Excel-Macros$$ Sumproduct with 3 criteria +

adine From: Dave Bonallack To: "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 if it has been answere

Re: $$Excel-Macros$$ Sumproduct with 3 criteria +

his > computer. > > Thanks so much. > > -- > *From:* Dave Bonallack > *To:* "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. > &

RE: $$Excel-Macros$$ Sumproduct with 3 criteria +

l, which I don't see how you can sum. Sorry I'm not understanding. Regards - Dave. Date: Tue, 3 Aug 2010 05:24:47 -0700 From: n8dine4ma...@yahoo.com Subject: Re: $$Excel-Macros$$ Sumproduct with 3 criteria + To: excel-macros@googlegroups.com Let me try this again. Sheet 1 ha

Re: $$Excel-Macros$$ Sumproduct with 3 criteria +

ooglegroups.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 if it = $R$

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 if it = $R$2 and if it = $R$1" I assume that if the result of the SumProduct formula = R2 AND = R3, then you want the result of the Sum

Re: $$Excel-Macros$$ Sumproduct

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 wrote: > Dear All, Can you tell me that what is the work of sum product. > > -- > Thanks For Mail. > > -- > > -

Re: $$Excel-Macros$$ Sumproduct

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