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
Hi Rajan,
Could you please elaborate?
Thanks,
Joseph
Sent on my BlackBerry® from Vodafone
-Original Message-
From: "Rajan_Verma"
Sender: excel-macros@googlegroups.com
Date: Fri, 17 Aug 2012 22:12:08
To:
Reply-To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macro
You can use DCount()
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Santosh Kumar Singh
Sent: 17 August 2012 10:14
To: excel-macros@googlegroups.com
Cc: dguille...@gmail.com
Subject: $$Excel-Macro
