+ Reply to Thread
Results 1 to 5 of 5

Probleem [NEDERLANDS]

  1. #1
    Registered User
    Join Date
    03-07-2014
    Location
    Eindhoven, Netherlands
    MS-Off Ver
    Sheet
    Posts
    17

    Probleem [NEDERLANDS]

    Weet iemand als je een paar kolommen bij elkaar wil optellen maar bij een kolom staat een tekst.
    Hoe kan je ervoor zorgen dat ie toch optelt zonder een error of fout?

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Probleem [NEDERLANDS]

    @extreming

    try respond in english, you will see you get a lot more response.

    14 21 red 15 te result is 50, when I use the formula sum(a1:d1)

    So please explain better.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    03-07-2014
    Location
    Eindhoven, Netherlands
    MS-Off Ver
    Sheet
    Posts
    17

    Re: Probleem [NEDERLANDS]

    I dont get you..
    You do understand Dutch right?

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,610

    Re: Probleem [NEDERLANDS]

    Excel will only add the numbers and numbers formatted as text ---> Google Translate --> Excel zal alleen de nummers en nummers opgemaakt als tekst toe te voegen


    F
    G
    1
    2
    2
    2
    3
    appel
    4
    SUM(G1:G3)
    4
    Last edited by protonLeah; 03-11-2014 at 02:15 AM.
    Ben Van Johnson

  5. #5
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Probleem [NEDERLANDS]

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

    To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Code Fout [NEDERLANDS]
    By Extreming in forum Non English Excel
    Replies: 2
    Last Post: 03-07-2014, 01:30 PM
  2. [SOLVED] Print macro probleem
    By BenBeer in forum Non English Excel
    Replies: 2
    Last Post: 02-09-2014, 11:38 PM
  3. Probleem met validatie (keuzemenu toont slechts tot rij 52)
    By dutchbb in forum Non English Excel
    Replies: 4
    Last Post: 05-17-2010, 10:53 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1