Results 1 to 7 of 7

Simple IF function

Threaded View

Hubertus C Simple IF function 09-23-2016, 08:00 AM
NBVC Re: Simple IF function 09-23-2016, 08:17 AM
Hubertus C Re: Simple IF function 09-23-2016, 09:19 AM
NBVC Re: Simple IF function 09-23-2016, 09:39 AM
Hubertus C Re: Simple IF function 09-23-2016, 09:52 AM
Hubertus C Re: Simple IF function 09-23-2016, 09:46 AM
NBVC Re: Simple IF function 09-23-2016, 09:53 AM
  1. #1
    Registered User
    Join Date
    05-17-2016
    Location
    Maastricht, The Net
    MS-Off Ver
    Office Mac 2011
    Posts
    4

    Simple IF function

    Hi all,

    I'm get a sheet every month with the hours that my employees worked.
    Now, I want a sheet to summarize the first sheet. This is (part of) the sheet with all the information that I want to use:

    Capture.PNG
    Attachment 481760
    It needs to check if Column F in the sheet2 above (the name) is the same is as in cell B4 (for example, see attachment below) in sheet 1. If the result is True, then it needs to add column H (the hours worked on 1 day) and add this value to the corresponding month in Sheet1. But all hours of that month, from a certain employee need to come in that cell.

    Capture2.PNG
    Attachment 481763

    Does anyone know how to do this? If you need more explanation, please tell me!

    Thanks for the help!
    Last edited by Hubertus C; 09-23-2016 at 08:03 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Simple IF function help, greater than and less than in same function
    By ExelDummy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-03-2015, 03:53 PM
  2. [SOLVED] Simple IF/Or function
    By hambly in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-07-2012, 03:38 PM
  3. need help with simple if function
    By J00 in forum Excel General
    Replies: 7
    Last Post: 06-07-2012, 10:25 AM
  4. simple DB function: trying sum & vlookup w/ array function
    By dlh in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-04-2007, 02:51 PM
  5. NEED HELP with simple function
    By Bernadette.Nicholas@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-28-2006, 07:25 PM
  6. simple if then function
    By N Harkawat in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-06-2005, 12:05 PM
  7. simple if then function
    By amy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 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