Re: $$Excel-Macros$$ CONDITIONAL SUM

Dear Ashok, You can also use.. *=SUM(IF(MONTH(A2:A7)=D3,B2:B7,""))* with CSE(Ctrl+shift+enter) -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* On Mon, Apr 2, 2012 at 1:25 PM, ASHOK PHALKE wrote: > Hi

RE: $$Excel-Macros$$ CONDITIONAL SUM

Hi Please find attached workbook Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ASHOK PHALKE Sent: Apr/Mon/2012 01:26 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ CONDITIONAL SUM Hi,Please help me. I have following Data

Re: $$Excel-Macros$$ CONDITIONAL SUM

My Try, Array formula, {=SUM(--(MONTH(Sheet1!A2:A7)=A1)*Sheet1!B2:B7)} Regards, MARIES. On Mon, Apr 2, 2012 at 5:47 PM, dguillett1 wrote: > =sumproduct((month(sheet1!a2:a200)=a1)*sheet1!b2:b200 > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread tit

Re: $$Excel-Macros$$ CONDITIONAL SUM

for January use 1 in cell a1 =sumproduct((month(sheet1!a2:a200)=a1)*sheet1!b2:b200) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: ASHOK PHALKE Sent: Monday, April 02, 2012 2:55 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ CONDITIONAL SUM Hi,Pl

Re: $$Excel-Macros$$ Conditional Sum by negative & positive value

My Try, For Negative, =SUM(IF(IF($A$2:$A$27=E2,$C$2:$C$27,0)<0,$C$2:$C$27,0)) For Positive, =SUM(IF(IF($A$2:$A$27=E2,$C$2:$C$27,0)>0,$C$2:$C$27,0)) Formula Apply with *CSE*. Regards, MARIES. +971502420957 On Tue, Mar 6, 2012 at 9:40 AM, NOORAIN ANSARI wrote: > Dear Ashish, > > You can also try

Re: $$Excel-Macros$$ Conditional Sum by negative & positive value

Dear Ashish, You can also try.. For Negative =SUMIFS($C$2:$C$27,$C$2:$C$27,"<"&0,$A$2:$A$27,$E2) For Positive =SUMIFS($C$2:$C$27,$C$2:$C$27,">"&0,$A$2:$A$27,$E2) -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogs

Re: $$Excel-Macros$$ Conditional Sum by negative & positive value

For Negatives - (in F2 and drag down) - =SUMPRODUCT(($A$2:$A$27=E2)*($C$2:$C$27<0)*$C$2:$C$27) For Positives - (in G2 and drag down) - =SUMPRODUCT(($A$2:$A$27=E2)*($C$2:$C$27>0)*$C$2:$C$27) Attached. HTH Abhishek On Tue, Mar 6, 2012 at 10:26 AM, Ashish Bhalara wrote: > Dear expert, > > I nee

Re: $$Excel-Macros$$ Conditional Sum or Sumproduct.

200.00 {(9750*6(April-Sep09 months) +9950*6(Sept 09-March 10) = >> 118200.) >> >> >> >> Hope it helps you to solve the crux . >> >> >> >> >> >> Regards, >> >> >> >> C.G.Kumar >> >> AMW-

RE: $$Excel-Macros$$ Conditional Sum or Sumproduct.

t: Re: $$Excel-Macros$$ Conditional Sum or Sumproduct. Hi C.G., Could you please elaborate more on what condition you would like to put in here? Regards, Andy On Fri, Oct 8, 2010 at 10:34 AM, C.G.Kumar wrote: I am looking for conditional sum i.e. sum based on criteria. But neither Sumprod

Re: $$Excel-Macros$$ Conditional Sum or Sumproduct.

Hi C.G., Could you please elaborate more on what condition you would like to put in here? Regards, Andy On Fri, Oct 8, 2010 at 10:34 AM, C.G.Kumar wrote: > I am looking for conditional sum i.e. sum based on criteria. But neither > Sumproduct nor SUMIFS and Pivot serve the purpose. > > Attached