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 -- ---------------------------------------------------------------------------------- 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
