Hi,Please help me.
I have following Data
Sheet1 Sheet2
Date Amount Month ( I am storing this field on
seperate sheet),*I need formula to sum for the spcific Month,changing value
of month in Sheet2*.
01/04/2012106
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
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 dguille...@gmail.com wrote:
=sumproduct((month(sheet1!a2:a200)=a1)*sheet1!b2:b200
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise,
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
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/*http://excelmacroworld.blogspot.com/
On Mon, Apr 2, 2012 at 1:25 PM, ASHOK PHALKE
For Negatives - (in F2 and drag down) -
=SUMPRODUCT(($A$2:$A$27=E2)*($C$2:$C$270)*$C$2:$C$27)
For Positives - (in G2 and drag down) -
=SUMPRODUCT(($A$2:$A$27=E2)*($C$2:$C$270)*$C$2:$C$27)
Attached.
HTH
Abhishek
On Tue, Mar 6, 2012 at 10:26 AM, Ashish Bhalara
ashishbhalar...@gmail.comwrote:
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.blogspot.com/
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 noorain.ans...@gmail.comwrote:
Dear
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 kumar.bemlmum...@gmail.comwrote:
I am looking for conditional sum i.e. sum based on criteria. But neither
Sumproduct nor SUMIFS and Pivot serve
...@googlegroups.com] *On Behalf Of *Aindril De
*Sent:* Friday, October 08, 2010 11:35 AM
*To:* excel-macros@googlegroups.com
*Subject:* 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
Attached sample file for the problem. Hope somebody among you will be able
to solve the crux.
Regards,
C.G.Kumar
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Attached sample file for the problem. Hope somebody among you will be able
to solve the crux.
Regards,
C.G.Kumar
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
I am looking for conditional sum i.e. sum based on criteria. But neither
Sumproduct nor SUMIFS and Pivot serve the purpose.
Attached sample file . Hope you will be able to solve the crux.
Regards,
C.G.Kumar
--
--
13 matches
Mail list logo