+ Reply to Thread
Results 1 to 3 of 3

Count formula, lookup or may sumif?

  1. #1
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Count formula, lookup or may sumif?

    I need to add the total of staffs hours worked for one day, but the problem is that I don't recieve the data as hours but as symbols(letters of the alphabet) representing time worked. Eg "A" is 3.5 hours, "B" is 4hours "C" is 4.5 hours ect, ect. In the example the top table is a one month time sheet for each staff and there working shifts. The bottom table is the part that I need a formula for. I need a total for each symbol for each day so I can total the hours at the bottom where it says total hours. I have given an example on how the bottom table should look when the formula is completed.TIA
    Attached Files Attached Files
    Last edited by JapanDave; 06-22-2009 at 05:38 AM.

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,440

    Re: Count formula, lookup or may sumif?

    Hi,

    In cell C21,

    =COUNTIF(C$5:C$11,$A21)*$B21

    and copy throughout the lower table
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Count formula, lookup or may sumif?

    Thanks for the help , that is what I was looking for.

+ Reply to Thread

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