2012 12:47 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Need formula to take out total number of
> boy and girl
>
> Dear all
> Can you please help me to find out Boys & girls Rank (Regarding Marks) If
> they failed then can not count their rank.
ett1 wrote:
See sumproduct formulas in attached.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: group birle
Sent: Wednesday, July 18, 2012 7:47 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need formula to take out total nu
product formulas in attached.
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>
> *From:* group birle
> *Sent:* Wednesday, July 18, 2012 7:47 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Need formula
See sumproduct formulas in attached.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: group birle
Sent: Wednesday, July 18, 2012 7:47 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need formula to take out total number of boy and
girl
check this
On Thu, Jul 12, 2012 at 2:54 PM, सुनिता पौडेल wrote:
> Dear all,
>
> Can you please help me to find out the total number of boy and girl ? I
> used countif for their grade and it worked. However, for girl and boy
> seggregation it isnot working.
>
> Thank you very much for the suppo
Hi Noorain,
Its working perfectly. I have tried this formulae for other sheets too.
Thanx alot...I need it for my report...
Have a wonderful weekend.
Sunita
On Fri, Jul 13, 2012 at 3:02 PM, NOORAIN ANSARI wrote:
> Hi Sunita,
>
> Please confirm..
>
> Is it not working..
>
> paste in Cell *E2*
Hi Sunita,
Please confirm..
Is it not working..
paste in Cell *E2*
*=SUMPRODUCT(--($E$10:$E$46=$E$1)*($D$10:$D$46=C2))*
On Fri, Jul 13, 2012 at 1:22 PM, सुनिता पौडेल wrote:
> Hi,
>
> Still not working :(
> its 2010
>
> On Fri, Jul 13, 2012 at 12:04 PM, NOORAIN ANSARI > wrote:
>
>> Incase of
Thank you so muck Krishnaraddi ji. Still wondering where it went wrong.
Anyway thanks heaps.
Sunita
On Fri, Jul 13, 2012 at 1:53 PM, Krishnaraddi V. Madolli <
krishnaraddi.mado...@asia.xchanging.com> wrote:
> "CONFIDENTIALITY NOTICE: This message and any attachment are confidential
> and may al
Hi,
Still not working :(
its 2010
On Fri, Jul 13, 2012 at 12:04 PM, NOORAIN ANSARI
wrote:
> Incase of 2003
>
> You can also use..
>
> *=SUMPRODUCT(--($E$10:$E$46=$E$1)*($D$10:$D$46=C2))*
>
>
> On Fri, Jul 13, 2012 at 11:48 AM, NOORAIN ANSARI > wrote:
>
>> Hi Sunita,
>>
>> Please Try it..
>> =CO
Incase of 2003
You can also use..
*=SUMPRODUCT(--($E$10:$E$46=$E$1)*($D$10:$D$46=C2))*
On Fri, Jul 13, 2012 at 11:48 AM, NOORAIN ANSARI
wrote:
> Hi Sunita,
>
> Please Try it..
> =COUNTIFS($E$10:$E$46,$E$1,$D$10:$D$46,C2)
>
>
>
>
> On Fri, Jul 13, 2012 at 11:31 AM, सुनिता पौडेल wrote:
>
>> Dear
Hi Sunita,
Please Try it..
=COUNTIFS($E$10:$E$46,$E$1,$D$10:$D$46,C2)
On Fri, Jul 13, 2012 at 11:31 AM, सुनिता पौडेल wrote:
> Dear all,
>
> however this is not working out , can you please solve this where i went
> wrong/
> thnx
>
> On Thu, Jul 12, 2012 at 3:36 PM, सुनिता पौडेल wrote:
>
>> w
Dear all,
however this is not working out , can you please solve this where i went
wrong/
thnx
On Thu, Jul 12, 2012 at 3:36 PM, सुनिता पौडेल wrote:
> wohoo so may options thnx guys ..it really worked out
>
> thank you so much
>
> Sunita
>
> On Thu, Jul 12, 2012 at 3:25 PM, NOORAIN ANSARI
>
wohoo so may options thnx guys ..it really worked out
thank you so much
Sunita
On Thu, Jul 12, 2012 at 3:25 PM, NOORAIN ANSARI wrote:
> You Can also use..
>
> *=DCOUNTA($E$9:$E$49,E9,G1:G2)*
> See attached sheet.
>
>
> On Thu, Jul 12, 2012 at 3:04 PM, NOORAIN ANSARI
> wrote:
>
>> Hi Sunita
You Can also use..
*=DCOUNTA($E$9:$E$49,E9,G1:G2)*
See attached sheet.
On Thu, Jul 12, 2012 at 3:04 PM, NOORAIN ANSARI wrote:
> Hi Sunita,
>
> You can also *try..
>
> =SUMPRODUCT(--($E$10:E49="GIRL"))*
>
> On Thu, Jul 12, 2012 at 2:54 PM, सुनिता पौडेल wrote:
>
>> Dear all,
>>
>> Can you please
Hi Sunita,
You can also *try..
=SUMPRODUCT(--($E$10:E49="GIRL"))*
On Thu, Jul 12, 2012 at 2:54 PM, सुनिता पौडेल wrote:
> Dear all,
>
> Can you please help me to find out the total number of boy and girl ? I
> used countif for their grade and it worked. However, for girl and boy
> seggregation
ease
consider the environment before printing this message
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of ?? ?
Sent: Thursday, July 12, 2012 2:59 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need formula to take out total number of
Dear Sunita,
Find the attached sheet.
Regards,
Kuldeep Singh
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*
On Thu, Jul 12, 2012 at 2:59 PM, सुनिता पौडेल wrote:
> wow thnx...
> is there any way to find ou
wow thnx...
is there any way to find out like in certain grade how many girl or boy
studies??
Thank you
On Thu, Jul 12, 2012 at 3:11 PM, Rohan Young wrote:
> just correct your answer
>
> =COUNTIF($E$10:E49,"GIRL")
>
> On Thu, Jul 12, 2012 at 2:54 PM, सुनिता पौडेल wrote:
> > Dear all,
> >
> > Ca
just correct your answer
=COUNTIF($E$10:E49,"GIRL")
On Thu, Jul 12, 2012 at 2:54 PM, सुनिता पौडेल wrote:
> Dear all,
>
> Can you please help me to find out the total number of boy and girl ? I used
> countif for their grade and it worked. However, for girl and boy
> seggregation it isnot working
Dear all,
Can you please help me to find out the total number of boy and girl ? I
used countif for their grade and it worked. However, for girl and boy
seggregation it isnot working.
Thank you very much for the support you all have been providing.
sunita
--
FORUM RULES (986+ members already BA
20 matches
Mail list logo