Dear Praksh, Thanks a lot for your help. It worked..
I have tried countifs function before passing on to the group...but could not get success. Do you have more some writeups on details of how & where to use countifs, sumifs etc... Best Regards, Amit On Wed, Aug 3, 2011 at 8:59 PM, Prakash Paul <jprakashp...@gmail.com> wrote: > Dear Amit, > > I have completed the report. Could you check and tell whether it is > sufficent for you. > > Give your feed back. > > Regards > Paul > > On Wed, Aug 3, 2011 at 2:18 PM, Amit Desai <amit.de...@bdoindia.co.in>wrote: > >> Dear All,**** >> >> ** ** >> >> Please help me on this at the earliest…**** >> >> ** ** >> >> I need your help *for giving correct formula *on MIS preparation. I have >> attached one excel file with 3 work sheet ;**** >> >> 1) 2 MIS format on first 2 worksheet & **** >> >> 2) sample data on last work sheet.**** >> >> **** >> >> I need say count of Opening stock with several criteria, down time with >> several criteria etc....**** >> >> For each head criterias are written below MIS format.**** >> >> **** >> >> Thanks a lot in Advance...**** >> >> ** ** >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Amit Desai >> *Sent:* 02 August 2011 21:10 >> >> *To:* excel-macros@googlegroups.com >> *Subject:* RE: $$Excel-Macros$$ Need help on MIS**** >> >> ** ** >> >> Dear All,**** >> >> ** ** >> >> Please help me on this at the earliest…**** >> >> ** ** >> >> * * >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Amit Desai >> *Sent:* 01 August 2011 17:29 >> *To:* excel-macros@googlegroups.com >> *Subject:* FW: $$Excel-Macros$$ Need help on MIS**** >> >> ** ** >> >> Dear All,**** >> >> ** ** >> >> Please help me on this at the earliest…**** >> >> ** ** >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Amit Desai >> *Sent:* 30 July 2011 09:59 >> *To:* excel-macros@googlegroups.com >> *Subject:* $$Excel-Macros$$ Need help on MIS**** >> >> ** ** >> >> Dear Expert,**** >> >> **** >> >> I need your help *for giving correct formula *on MIS preparation. I have >> attached one excel file with 3 work sheet ;**** >> >> 1) 2 MIS format on first 2 worksheet & **** >> >> 2) sample data on last work sheet.**** >> >> **** >> >> I need say count of Opening stock with several criteria, down time with >> several criteria etc....**** >> >> For each head criterias are written below MIS format.**** >> >> **** >> >> Thanks a lot in Advance...**** >> >> **** >> >> Best Regards,**** >> >> Amit**** >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel**** >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel**** >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel**** >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
