Thanx Aindril,
I appreciate.
Only that it's doing the reverse, it's finding sum for those who attempted
less than 8 subjects.
What I wanted is it finding sum if only one atempted either 8 or more
subjects
the sum found should be for the least 8 subjects of all the attempted
e.g 1) If some one attempted 12 subjects it should find the sum for the
least 8 subjects
2) If some one attmpted only 7 subjects it shoould insert the word
"missed some subjects"
3) if some one attmped 8 subjects it should find the sum of those 8
subjects
Tahnx very much
On 2 November 2010 15:24, Aindril De <aind...@gmail.com> wrote:
> Hi,
>
> It looks like your calculations are not working as you are Displaying the
> numbers as text. For Example:
> The following Formula:
> =
> IF(sheet1!Q2>74,"1",IF(sheet1!Q2>69,"2",IF(sheet1!Q2>64,"3",IF(sheet1!Q2>59,"4",IF(sheet1!Q2>49,"5",IF(sheet1!Q2>44,"6",IF(sheet1!Q2>39,"7",IF(sheet1!Q2>29,"8",IF(sheet1!Q2>1,"9","")))))))))
>
> Can be written as:
> =
> IF(sheet1!Q2>74,1,IF(sheet1!Q2>69,2,IF(sheet1!Q2>64,3,IF(sheet1!Q2>59,4,IF(sheet1!Q2>49,5,IF(sheet1!Q2>44,6,IF(sheet1!Q2>39,7,IF(sheet1!Q2>29,8,IF(sheet1!Q2>1,9,"")))))))))
>
> "1" (text) changed to 1 (numeric)
>
> After you have modified your formulas, then in the final column you can use
> the formula:
>
>
> =IF(COUNTIF(A2:BL2,"missed")<8,"Missed",SUM(D2,H2,L2,P2,T2,X2,AB2,AF2,AJ2,AN2,AR2,AV2,AZ2,BD2,BH2,BL2))
>
> Copy down the formula to the last row of your range and it should give you
> the desired result.
>
> Regards,
> Andy
>
> On Tue, Nov 2, 2010 at 5:36 PM, Aindril De <aind...@gmail.com> wrote:
>
>> Hi Ayoub,
>>
>> Can you please explain this:
>>
>> Of these columns some lack data if less than 8 of the above columns lack
>> data word "missed" should appear
>>
>> Regards,
>> Andy
>>
>> On Tue, Nov 2, 2010 at 3:20 PM, ayoub Kakande <akaka...@gmail.com> wrote:
>>
>>> Good afternoon
>>> I need some help on a project that is buzzing ma head
>>> attached is the excel file
>>> help is need on sheet 2
>>> 1) I need a formula to find the sum of the least 8 columns
>>> 2) The columns are
>>> D2,H2,L2,P2,T2,X2,AB2,AF2,AJ2,AN2,AR2,AV2,AZ2,BD2,BH2,BL2
>>> 3) Of these columns some lack data if less than 8 of the above columns
>>> lack data word "missed" should appear
>>>
>>>
>>> --
>>> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>>
>>
>>
> --
>
> ----------------------------------------------------------------------------------
> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
