*Subject:* Re: $$Excel-Macros$$ Formula: Count
** **
Hello,
Thank a lot its working fine.
Regards,
Chandra
On Thu, Sep 19, 2013 at 12:08 PM, Ravinder ravinderexcelgr...@gmail.com
wrote:
PFA OR USE
=SUM((C2=IF(FREQUENCY(MATCH($A$2
18, 2013 4:13 PM
To: excel-macros@googlegroups.com
Cc: ashish koul
Subject: Re: $$Excel-Macros$$ Formula: Count
Hello,
Thanks for your replies. Formulas are working for one set of data but its
not working for other criterias I have attached new excel could you please
check it.
Ashish - I
)
WITH CSE
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar
*Sent:* Wednesday, September 18, 2013 4:13 PM
*To:* excel-macros@googlegroups.com
*Cc:* ashish koul
*Subject:* Re: $$Excel-Macros$$ Formula: Count
** **
Hello
Of Chandra Shekar
Sent: Thursday, September 19, 2013 1:24 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Formula: Count
Hello,
Thank a lot its working fine.
Regards,
Chandra
On Thu, Sep 19, 2013 at 12:08 PM, Ravinder ravinderexcelgr...@gmail.com
wrote:
PFA OR USE
=SUM
=SUM(IF(FREQUENCY(IFERROR(--SUBSTITUTE((C2=$A$2:$A$12)*($B$2:$B$12),0,),
),IFERROR(--SUBSTITUTE((C2=$A$2:$A$12)*($B$2:$B$12),0,),)),1))
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Chandra Shekar
Sent: Tuesday, September 17, 2013 6:00 PM
To:
Hello,
Thanks for your replies. Formulas are working for one set of data but its
not working for other criterias I have attached new excel could you please
check it.
*Ashish - *I am trying to get count of unique records based on multi
conditions where I know what is Condition1 but I will be not
xy1? what does this mean do you want to count RS with point 1 and so on
Regards
Ashish
On Tue, Sep 17, 2013 at 5:59 PM, Chandra Shekar
chandrashekarb@gmail.com wrote:
Hello,
I need formula to count no of points based on condtion please find
attached file.
Thanks,
Chandra
--
Check the Attachment...
On Tue, Sep 17, 2013 at 8:45 PM, ashish koul koul.ash...@gmail.com wrote:
xy1? what does this mean do you want to count RS with point 1 and so on
Regards
Ashish
On Tue, Sep 17, 2013 at 5:59 PM, Chandra Shekar
chandrashekarb@gmail.com wrote:
Hello,
I
Subject: Re: $$Excel-Macros$$ Formula: Count
Check the Attachment...
On Tue, Sep 17, 2013 at 8:45 PM, ashish koul koul.ash...@gmail.com
mailto:koul.ash...@gmail.com wrote:
xy1? what does this mean do you want to count RS with point 1 and so on
Regards
Ashish
On Tue, Sep 17, 2013 at 5