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
