the columns in total are over 15 so if more than 8 columns have data in them
I want to get a sum of th least 8, but if only 7 columns have data then the
sum shoulld not be put in.
coz what might happen is if some one attempted only 3 subjects it might
compute his sum which i don't want.

On 2 November 2010 15:06, 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

Reply via email to