Ms. Exl Learner,
G8
Working absolutely Fine.
Thanks,
Santosh Singh
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ms-Exl-Learner .
Sent: Wednesday, August 22, 2012 1:27 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need a
Try This...
=SUMPRODUCT(('Jan12'!F4:F60={"Corrective","Implementation","Training","Information"})*('Jan12'!H4:H60="DATA")*('Jan12'!G4:G60="Completed"))
Let us know in case of any further assistance.
---
Ms.Exl.Learner
---
On Fri, Aug 17, 2012 at 10:13 PM,
Dear Santosh,
Please share a workbook with formula
On Fri, Aug 17, 2012 at 10:13 PM, Santosh Kumar Singh wrote:
> Dear Group,
>
> Please suggest
>
> How we can reduce this formula (if Possible)
>
> ** **
>
>
> =COUNTIFS('Jan12'!F4:F60,"=Corrective",'Jan12'!H4:H60,"=DATA",'Jan12'!G4
...@gmail.com
Sent: 17 August 2012 10:16
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need a Suggestion for the formula
Hi Rajan,
Could you please elaborate?
Thanks,
Joseph
Sent on my BlackBerryR from Vodafone
_
From: "Rajan_Verma"
Sender: ex
@gmail.com
Subject: $$Excel-Macros$$ Need a Suggestion for the formula
Dear Group,
Please suggest
How we can reduce this formula (if Possible)
=COUNTIFS('Jan12'!F4:F60,"=Corrective",'Jan12'!H4:H60,"=DATA",'Jan12'!G4:G60
,"=Complete
-Macros$$ Need a Suggestion for the formula
Dear Group,
Please suggest
How we can reduce this formula (if Possible)
=COUNTIFS('Jan12'!F4:F60,"=Corrective",'Jan12'!H4:H60,"=DATA",'Jan12'!G4:G60
,"=Completed")+COUNTIFS('Jan12
Dear Group,
Please suggest
How we can reduce this formula (if Possible)
=COUNTIFS('Jan12'!F4:F60,"=Corrective",'Jan12'!H4:H60,"=DATA",'Jan12'!G4:G60
,"=Completed")+COUNTIFS('Jan12'!F4:F60,"=Implementation",'Jan12'!H4:H60,"=DA
TA",'Jan12'!G4:G60,"=Completed")+COUNTIFS('Jan12'!F4:F60,"=Traini
