Thank you!
On Tue, Nov 22, 2011 at 10:30 AM, Jedi Spencee jedi.spen...@gmail.comwrote:
Hello- I am trying to write a formula that would return the COUNT and
SUM, with 3 criteria elements.
IF(AND(data!F:F = A),and(data!B:B, = 04 - Closed Won), and(data!
D:D, = Oct-11),count, 0)
Can this
Hi,
If you are using Excel 2007 or 2010, then you can use the SUMIFS or
COUNTIFS to achieve the same.
Cheers
Andy
On Tue, Nov 22, 2011 at 11:00 PM, Jedi Spencee jedi.spen...@gmail.comwrote:
Hello- I am trying to write a formula that would return the COUNT and
SUM, with 3 criteria elements.
You can also try...
=SUMPRODUCT((data!F:F = A)*(data!B:B=04 - Closed
Won)*(data!D:D=Oct-11)*(data!K:K=0))
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On
If you are using Excel 2007+, use COUNTIFS for count and SUMIFS for sum.
If using an older Excel, use SUMPRODUCT for either.
IF(AND(data!F:F = A),and(data!B:B, = 04 - Closed Won), and(data!
D:D, = Oct-11),count, 0)
=COUNTIFS(data!F:F,A,data!B:B,04 - Closed Won,data!D:D,DATE(2011,10,1))
I think
-Original Message-
From: Asa Rossoff [mailto:a...@lovetour.info]
Sent: Tuesday, November 22, 2011 7:38 PM
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ Need Help with IF(AND formula
If you are using Excel 2007+, use COUNTIFS for count and SUMIFS for sum.
If using an older Excel
Thanks Harry
i want formula for Column D. the formula what i have mention in email needs
to be enhance or change
1. if for code in column A, status in column C is Paid,Not Paid,Awaiting
then Final Status should be Not to process in column D
2. if for code in column A, status in column C is
Enter Following Formula in Cell D2
=IF(C2=Paid,Process,IF(C2=,,(Not to Process)))
Regards
Jagjeet SIngh
On May 14, 8:55 pm, Mahesh parab mahes...@gmail.com wrote:
Dear All
for attach sheet i need formula or macro, I will appreciate any help on
this.
1.if for code in column A ,status in
check the sheet.
On Fri, May 14, 2010 at 9:25 PM, Mahesh parab mahes...@gmail.com wrote:
Dear All
for attach sheet i need formula or macro, I will appreciate any help on
this.
1.if for code in column A ,status in column C is paid then D column status
should be process
2.if status in