Results 1 to 8 of 8

How to count the total per day for one team member

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Austria
    MS-Off Ver
    Excel 2007
    Posts
    457

    How to count the total per day for one team member

    Dear all,

    I have trouble comming up with a formula that would do the following:
    There is one workbook that has 2 sheets. the first sheet is where you find the totals and the second sheet is where the data is.
    It should look in sheet 2 and then check based on name and date the amount for that day.
    So if as in the example attached Peter was the one doing 12 that day, it should appear the amount on that name in sheet 1.
    If the next day Paula would do 24, then it will put 24 on her name based on the date in cell C2.

    I hope some one can help out.
    Thanks in advance.
    megatronixs
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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