Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl
On Thu, Jul 19, 2012 at 5:35 PM, dguillett1 wrote: > Your file did NOT show any pass/fail or grades so how can we help? > > Don Guillett > Microsoft Excel Developer > SalesAid Software > dguille...@gmail.com > > *From:* amar takale > *Sent:* Thursday, July 19, 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.Can I got this formula > Thank you very much for the support you all have been providing. > > Amar > > > On Wed, Jul 18, 2012 at 6:56 PM, dguillett1 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 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 support you all have been providing. >>> >>> sunita >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> -- >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> To unsubscribe, send a blank email to >>> mailto:excel-macros%2bunsubscr...@googlegroups.com >> >> >> -- >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> mailto:excel-macros%2bunsubscr...@googlegroups.com >> >> >> -- >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a
Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl
Your file did NOT show any pass/fail or grades so how can we help? Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: amar takale Sent: Thursday, July 19, 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.Can I got this formula Thank you very much for the support you all have been providing. Amar On Wed, Jul 18, 2012 at 6:56 PM, dguillett1 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 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 support you all have been providing. sunita -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@googlegroups.com -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@googlegroups.com -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@googlegroups.com -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or co
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.Can I got this formula Thank you very much for the support you all have been providing. Amar On Wed, Jul 18, 2012 at 6:56 PM, dguillett1 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 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 support you all have been providing. >> >> sunita >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> mailto:excel-macros%2bunsubscr...@googlegroups.com > > > -- > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > > > -- > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > > -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl
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 support you all have been providing. sunita -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@googlegroups.com -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com BGA.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
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 support you all have been providing. > > sunita > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com BGA.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl
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* > *=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 < >> noorain.ans...@gmail.com> 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 < >>> noorain.ans...@gmail.com> 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 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 < >> noorain.ans...@gmail.com> 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 < >>> noorain.ans...@gmail.com> 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 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 BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like > Please Help, Urgent, Need Help, Formula Problem, Code Problem, and > Need > Advice will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any > security measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this > forum in signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a > workbook. Forum owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com >>> >>> >>> -- >>> Thanks & regards, >>> Noorain Ansari >>> www.noorainansari.com >>> www.excelmacroworld.blogspot.com >>> >>> >>> >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like >>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>> Advice will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum >>> in signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> -- >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> To unsubscribe, send a blank email to >>> excel-macros+unsubscr...@googlegroups.com >>> >> >> > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use con
Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl
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 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 < >> noorain.ans...@gmail.com> 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 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 < > noorain.ans...@gmail.com> 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 < >> noorain.ans...@gmail.com> 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 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 BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com >>> >>> >>> >>> >>> -- >>> Thanks & regards, >>> Noorain Ansari >>> www.noorainansari.com >>> www.excelmacroworld.blogspot.com >>> >>> >>> >>> >>> >> >> >> -- >> Thanks & regards, >> Noorain Ansari >> www.noorainansari.com >> www.excelmacroworld.blogspot.com >> >> >> >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like >> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >> Advice will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum >> in signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. >> Forum owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com >> > > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad.
Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl
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 also be privileged. If you are not the intended recipient of this > e-mail you may not copy, forward, disclose or otherwise use it or any part > of it in any form whatsoever. If you are not the intended recipient please > telephone or e-mail the sender and delete this message and any attachment > from your system." > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl
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.. >> =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: >>> 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 < noorain.ans...@gmail.com> 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 < > noorain.ans...@gmail.com> 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 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 BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like >>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>> Advice will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum >>> in signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> -- >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> To unsubscribe, send a blank email to >>> excel-macros+unsubscr...@googlegroups.com >> >> >> >> >> -- >> Thanks & regards, >> Noorain Ansari >> www.noorainansari.com >> www.excelmacroworld.blogspot.com >> >> >> >> >> > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like > Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need > Advice will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum > in signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. > Forum owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> -- >>> To post to this group, send
Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl
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 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 < >>> noorain.ans...@gmail.com> 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 < noorain.ans...@gmail.com> 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 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 BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like >> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >> Advice will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum >> in signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. >> Forum owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com > > > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > > > > -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com >>> >>> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com >> > > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > > > > -- Thanks & regards, Noor
Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl
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: > >> 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 < >>> noorain.ans...@gmail.com> 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 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 BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like > Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need > Advice will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum > in signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. > Forum owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com >>> >>> >>> -- >>> Thanks & regards, >>> Noorain Ansari >>> www.noorainansari.com >>> www.excelmacroworld.blogspot.com >>> >>> >>> >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> -- >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> To unsubscribe, send a blank email to >>> excel-macros+unsubscr...@googlegroups.com >>> >> >> > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any securit
Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl
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 > 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 *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 it isnot working. Thank you very much for the support you all have been providing. sunita -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com >>> >>> >>> >>> >>> -- >>> Thanks & regards, >>> Noorain Ansari >>> www.noorainansari.com >>> www.excelmacroworld.blogspot.com >>> >>> >>> >>> >>> >> >> >> -- >> Thanks & regards, >> Noorain Ansari >> www.noorainansari.com >> www.excelmacroworld.blogspot.com >> >> >> >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com >> > > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Book3.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl
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 *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 it isnot working. >>> >>> Thank you very much for the support you all have been providing. >>> >>> sunita >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> -- >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> To unsubscribe, send a blank email to >>> excel-macros+unsubscr...@googlegroups.com >> >> >> >> >> -- >> Thanks & regards, >> Noorain Ansari >> www.noorainansari.com >> www.excelmacroworld.blogspot.com >> >> >> >> >> > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl
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 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 BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com > > > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > > > > -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Copy of BGA-1(DCOUNTA).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl
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 it isnot working. > > Thank you very much for the support you all have been providing. > > sunita > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
RE: $$Excel-Macros$$ Need formula to take out total number of boy and girl
You can use COUNTIFS function. Regards, Krishnaraddi V Madolli. Data Analytics Team Sedgwick Claims Management Services, Inc. Xchanging Towers, SJR iPark, EPIP Area, Whitefield Bangalore - 560 066. India. Direct Line: +1.800.920.9657 Extn 1915 Switchboard: +90-(0)80-3054 Extn 1915 Email: krishnaraddi.mado...@asia.xchanging.com<mailto:krishnaraddi.mado...@asia.xchanging.com> krishnaraddi.mado...@sedgwickcms.com<mailto:krishnaraddi.mado...@sedgwickcms.com> www.sedgwickcms.com<https://outlook.us.xchanging.com/exchweb/bin/redir.asp?URL=http://www.sedgwickcms.com> | The leader in innovative claims and productivity management solutions Success is never permanent, Failure is never final, so always do not stop effort until your victory makes a history. [http://images.coolchaser.com/themes/t/404137-i311.photobucket.com-albums-kk467-volleycutiegirl-icon.png]Please 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 boy and girl 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 mailto:rohan.j...@gmail.com>> wrote: just correct your answer =COUNTIF($E$10:E49,"GIRL") On Thu, Jul 12, 2012 at 2:54 PM, सुनिता पौडेल mailto:tosune...@gmail.com>> 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 support you all have been providing. > > sunita > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will > not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > -- > To post to this group, send email to > excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com> > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com<mailto:excel-macros%2bunsubscr...@googlegroups.com> -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com> To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com<mailto:excel-macros%2bunsubscr...@googlegroups.com> -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com<mailto:excel-macros@googlegroups
Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl
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 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, >> > >> > 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 BANNED for violation) >> > >> > 1) Use concise, accurate thread titles. Poor thread titles, like Please >> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will >> > not get quick attention or may not be answered. >> > >> > 2) Don't post a question in the thread of another member. >> > >> > 3) Don't post questions regarding breaking or bypassing any security >> > measure. >> > >> > 4) Acknowledge the responses you receive, good or bad. >> > >> > 5) Cross-promotion of, or links to, forums competitive to this forum in >> > signatures are prohibited. >> > >> > NOTE : Don't ever post personal or confidential data in a workbook. >> Forum >> > owners and members are not responsible for any loss. >> > >> > >> -- >> > To post to this group, send email to excel-macros@googlegroups.com >> > >> > To unsubscribe, send a blank email to >> > excel-macros+unsubscr...@googlegroups.com >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. >> Forum owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com >> > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com BGA.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl
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, > > > > 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 BANNED for violation) > > > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will > > not get quick attention or may not be answered. > > > > 2) Don't post a question in the thread of another member. > > > > 3) Don't post questions regarding breaking or bypassing any security > > measure. > > > > 4) Acknowledge the responses you receive, good or bad. > > > > 5) Cross-promotion of, or links to, forums competitive to this forum in > > signatures are prohibited. > > > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > > owners and members are not responsible for any loss. > > > > > -- > > To post to this group, send email to excel-macros@googlegroups.com > > > > To unsubscribe, send a blank email to > > excel-macros+unsubscr...@googlegroups.com > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl
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. > > Thank you very much for the support you all have been providing. > > sunita > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will > not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Need formula to take out total number of boy and girl
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 BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com BGA.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
