Results 1 to 10 of 10

Headcount: How to count blank cells with corresponding data in same row?

Threaded View

  1. #1
    Registered User
    Join Date
    04-11-2019
    Location
    Pennsylvania, USA
    MS-Off Ver
    MS Office 365
    Posts
    10

    Headcount: How to count blank cells with corresponding data in same row?

    Hello!

    Say I have a table where I am signing in visiters with a TIME IN and TIME OUT columns. I would like to count those who have been signed in but not yet signed out. I want this to be automatic so my employees can know the active headcount without having to know how to use function or count manually.

    Example:
    Lets just say I would have preset 500 rows on my table and by end of day I signed in 200 people.
    Who out of the 500 rows has been signed in but not signed out yet?
    Last edited by msjesbrown93; 04-16-2019 at 11:40 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Calculate Count of Text in Blank Cells (Random Data)
    By a1ksingh in forum Excel General
    Replies: 3
    Last Post: 06-09-2016, 11:51 PM
  2. Count blank cells in a range and contiguous blank cells also as single cells! Tricky One!
    By SebastianColombia in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-31-2015, 02:32 PM
  3. How to count blank cells in data range
    By puttu in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-11-2013, 01:48 PM
  4. Replies: 1
    Last Post: 07-17-2013, 11:34 AM
  5. Need to count Blank cells instead of data cells in Pivot table
    By plb999 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-19-2012, 09:01 PM
  6. [SOLVED] VBA to count cells with data between blank rows
    By Philcater in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-21-2012, 04:40 PM
  7. Counting data in non blank cells and exclude certain data from the count
    By JohnG73 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-04-2007, 04:08 PM

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