Yes, this might be true as there is one range name used in formula, defined by the name of "dkp", which you should first create the same in your Excel. Alternatively, you can manually replace the NAME used in formula with actual cell refrences to make it more dyamic.
Feel free to revert in case of any queries. Regards, DILIPandey On 6/1/11, ayoub Kakande <akaka...@gmail.com> wrote: > Hello, > does that formula apply to only office 03 coz when I copy it to my > original workbook which is in office 7 it brings a name error > > On 1 June 2011 09:06, Dilip Pandey <dilipan...@gmail.com> wrote: >> HI Ayoub, >> >> This is done with the help of nesting formula having functions like >> Small, Row and Sum. >> See the attached file and feel free to revert in case of any queries. >> Thanks. >> >> Best Regards, >> DILIPandey >> >> On 6/1/11, ayoub Kakande <akaka...@gmail.com> wrote: >>> Hello have attached the file >>> Need to find the sum of least 8 from >>> (f2,l2,r2,x2,ad2,aj2,ap2,av2,bb2,bh2,bn2,bt2,bz2,cf2) >>> Tnax >>> >>> On 31 May 2011 17:37, DILIPandey <dilipan...@gmail.com> wrote: >>>> Hi Ayoub, >>>> >>>> It would be very helpful for the "Group" if you can share a sample >>>> scenario of your problem. >>>> >>>> Thanks, >>>> DILIPandey >>>> >>>> On May 31, 2:45 pm, ayoub Kakande <akaka...@gmail.com> wrote: >>>>> Urgent help needed >>>>> >>>>> I have 18 subjects, 6 of them are compulsory from the other 12 a >>>>> student offers only 2 to make a total of either 9 or ten >>>>> subjects/papers. >>>>> I need a formula to computer the sum of the least eight subjects done >>>>> for each student. >>>>> N.b if a student attempts less than 8 subjects it should not compute >>>>> for him the total. >>>>> These subjects are not in consecutive columns >>>>> Thanx >>>>> >>>>> -- >>>>> Ayoub Kakande >>>>> 0772656158 / 0703516660 >>>>> Data - Mujhu >>>>> Mulago Hosp >>>> >>>> -- >>>> ---------------------------------------------------------------------------------- >>>> 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 >>>> >>> >>> >>> >>> -- >>> Ayoub Kakande >>> 0772656158 / 0703516660 >>> Data - Mujhu >>> Mulago Hosp >>> >>> -- >>> ---------------------------------------------------------------------------------- >>> 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 >>> >> >> >> -- >> Thanks & Regards, >> >> DILIP KUMAR PANDEY, mvp >> MBA,B.Com(Hons),BCA >> Mobile: +91 9810929744 >> dilipan...@gmail.com >> dilipan...@yahoo.com >> New Delhi - 62, India >> > > > > -- > Ayoub Kakande > 0772656158 / 0703516660 > Data - Mujhu > Mulago Hosp > -- Sent from my mobile device Thanks & Regards, DILIP KUMAR PANDEY, mvp MBA,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- ---------------------------------------------------------------------------------- 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
