+ Reply to Thread
Results 1 to 3 of 3

Count name values on X and Y axis criteria

  1. #1
    Registered User
    Join Date
    03-30-2014
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    61

    Count name values on X and Y axis criteria

    Hi Gurus

    Thanks for helping my every time!

    I am familiar with the CountIFS function, however I don't get it to work with this scenario.

    We have a team of 7 employees who locks up our shop every weekend and opens it again. I need to count how many times each employee opens and closes on the respective weekend days.

    There is a tabel at the bottom which I need to summarize the counts.

    Fridays we only count the CLOSING, Saturday the person who closed Friday opens Saturday and leaves at 11:00, then the second person works from 11:00 till closing, as well as the whole Sunday.

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,778

    Re: Count name values on X and Y axis criteria

    Would you manually complete the expected results since it's possible to interpret this in different ways.

    For instance:
    Is the summary required for one month or all months?
    Are you wanting to count the occasions where an employee both Closes on one day AND opens on the next day - and does this count as 1 or 2 events,
    OR count the occasison when an employee EITHER closes or opens on one of the days?
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2010
    Posts
    5,686

    Re: Count name values on X and Y axis criteria

    In D43 then copied across.
    Please Login or Register  to view this content.
    Note the change in heading of Main table Row 2 (TOE,OOP).
    Note the change in heading of Days Row 42.
    Attached Files Attached Files
    Last edited by kvsrinivasamurthy; 10-08-2019 at 09:24 AM.
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

+ 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. Replies: 2
    Last Post: 07-30-2018, 02:21 PM
  2. Replies: 4
    Last Post: 11-01-2016, 03:28 PM
  3. Replies: 2
    Last Post: 01-21-2014, 02:53 PM
  4. [SOLVED] Count values in one list and then narrow/combine values based on criteria
    By razz0807 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-13-2013, 08:02 AM
  5. Replies: 8
    Last Post: 02-12-2009, 10:12 AM
  6. Count values between two criteria
    By The_jackal in forum Excel - New Users/Basics
    Replies: 22
    Last Post: 06-04-2008, 11:28 AM
  7. [SOLVED] How to insert X axis scale values next to axis and X axis grid lin
    By vp23larry in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-23-2005, 11:05 AM

Tags for this Thread

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