Re: $$Excel-Macros$$ Re: sum of least 8 subjects

2011-06-06 Thread Dilip Pandey
Good to know. You are welcome. Regards, DILIPandey On 6/6/11, ayoub Kakande wrote: > Thank you sososo much, > it has worked out just perfectly > thanx again. > > On 5 June 2011 20:58, Dilip Pandey wrote: >> Hi Ayoub, >> >> If you remove the named range and type the desired cell reference like >

Re: $$Excel-Macros$$ Re: sum of least 8 subjects

2011-06-01 Thread Dilip Pandey
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

Re: $$Excel-Macros$$ Re: sum of least 8 subjects

2011-06-01 Thread ayoub Kakande
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 wrote: > HI Ayoub, > > This is done with the help of nesting formula having functions like > Small, Row and Sum. > See the att

$$Excel-Macros$$ Re: sum of least 8 subjects

2011-05-31 Thread DILIPandey
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 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