Good to know.
You are welcome.
Regards,
DILIPandey
On 6/6/11, ayoub Kakande <akaka...@gmail.com> wrote:
> Thank you sososo much,
> it has worked out just perfectly
> thanx again.
>
> On 5 June 2011 20:58, Dilip Pandey <dilipan...@gmail.com> wrote:
>> Hi Ayoub,
>>
>> If you remove the named range and type the desired cell reference like
>> below and enter the formula as array (Ctrl+Shift+Enter), you will get
>> the desired results:-
>>
>> {=SUM(SMALL((F2,L2,R2,X2,AD2,AJ2,AP2,AV2,BB2,BH2,BN2,BT2,BZ2,CF2),ROW($CP$1:$CP$8)))}
>>
>> Attached workbook is also formulated as per your queries.
>>
>> Best regards,
>> DILIPandey
>>
>> On 6/2/11, ayoub Kakande <akaka...@gmail.com> wrote:
>>> Hello
>>> Yhank you very much for your help.
>>> Have understood the bit abut naming the cell range.
>>> I have got another hitch,
>>> 1)when I auto fill the formula it brings an error.
>>> 2) when i change the values in row 2 it brings an error in all subsequent
>>> rows.
>>> I have attached it for you to see.
>>> once aganin thanx coz yo my saviour.
>>>
>>> On 1 June 2011 19:03, Dilip Pandey <dilipan...@gmail.com> wrote:
>>>> 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
>>>>
>>>
>>>
>>>
>>> --
>>> Ayoub Kakande
>>> 0772656158 / 0703516660
>>> Data - Mujhu
>>> Mulago Hosp
>>>
>>
>>
>> --
>> 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
