+ Reply to Thread
Results 1 to 5 of 5

verticaal zoek en som

  1. #1
    Registered User
    Join Date
    03-04-2022
    Location
    netherlands
    MS-Off Ver
    365
    Posts
    3

    Post verticaal zoek en som

    test.xlsx

    Wie kan mij helpen om in het 1e tablad het totaal te krijgen van minuten uit het 2e tabblad.

    Blad 1:
    Naam clientnr bedrag tijd
    Lola 3 600 in kolom d moet 330 komen te staan met welke formule?
    Lola 3
    Ano 6 600 in kolom d moet 490 komen te staan met welke formule?
    Ano 6

    Blad 2:

    clientnr naam tijd
    3 Lola 10
    3 Lola 30
    3 Lola 45
    3 Lola 80
    3 Lola 120
    3 Lola 15
    3 Lola 30
    4 bruno 15
    4 bruno 75
    4 bruno 80
    4 bruno 60
    4 bruno 45
    6 Ano 30
    6 Ano 50
    6 Ano 60
    6 Ano 45
    6 Ano 120
    6 Ano 90
    6 Ano 20
    6 Ano 15
    6 Ano 60


    Hoorhet graag wie me kan helpen.

    Mvrgr,

    Helsib
    Last edited by 6StringJazzer; 03-04-2022 at 03:08 PM. Reason: Please note we are an English-language forum. I have moved your post from Excel - New Users/Basics

  2. #2
    Valued Forum Contributor
    Join Date
    09-30-2018
    Location
    Vlaams Brabant Belgium
    MS-Off Ver
    365
    Posts
    445

    Re: verticaal zoek en som

    Hallo,

    In dit geval gebruik je de formule Sommen.als


    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Please be as complete as possible in your asking so it may save use all the time to rework the solution because you didn't give all the requirements. If you have a layout in mind please work it out first so we can adapt our solution to it. Thanks.
    If you have been helped, maybe you could click the *

  3. #3
    Registered User
    Join Date
    03-04-2022
    Location
    netherlands
    MS-Off Ver
    365
    Posts
    3

    Re: verticaal zoek en som

    Dank je wel Joske920,

    Ik had een test bestandje toegevoegd. Met de formule lukt het nu niet bij 2 verschillende tabbladen. Hoor het graag wat anders kan.

    Mvrgr

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,581

    Re: verticaal zoek en som

    Zoiets misschien ?

    Er zijn verschillende mogelijkheden
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    03-04-2022
    Location
    netherlands
    MS-Off Ver
    365
    Posts
    3

    Re: verticaal zoek en som

    dank je wel is gelukt

+ 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. [SOLVED] Verticaal zoeken werkt niet goed
    By yoyoo in forum Non English Excel
    Replies: 2
    Last Post: 09-06-2020, 05:01 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