Results 1 to 8 of 8

Adjustments to sumproduct to ignore if all entries at each date is blank

Threaded View

  1. #1
    Registered User
    Join Date
    03-08-2019
    Location
    Denmark
    MS-Off Ver
    Office 365
    Posts
    57

    Exclamation Adjustments to sumproduct to ignore if all entries at each date is blank

    Hi there,

    I am struggling with a formula to count the number of non-blank cells in a range of dates, however, excluding dates that have ONLY blank entries (04-01-2019 in the workbook).

    Basically, I have a number of dates spread across the employees of 4 companies. For each company, I'd like to know how many employees were present over the period.

    A "blank entry" corresponds to an absent employee, whereas an "employee name" represents a present employee.

    Please see the enclosed sample workbook for a more detailed description.

    Thanks,
    Phil
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. SUMIF Job Entries Over Date Range + Ignore Duplicate Job Entries
    By sansai in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-07-2019, 09:12 PM
  2. sumproduct formula to ignore blank values
    By Look, More, What in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-17-2018, 05:43 PM
  3. Sumproduct - ignore blank cells
    By pauldaddyadams in forum Excel General
    Replies: 3
    Last Post: 04-23-2014, 11:42 AM
  4. Ignore Blank Cells in SUMPRODUCT formula
    By taniwha in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-22-2013, 10:52 AM
  5. Sumproduct: how to ignore blank variables
    By robotlust in forum Excel General
    Replies: 5
    Last Post: 05-17-2012, 11:02 PM
  6. [SOLVED] How to get Sumproduct to ignore a criteria if it is blank?
    By skysurfer in forum Excel General
    Replies: 3
    Last Post: 04-29-2012, 04:54 PM
  7. Replies: 2
    Last Post: 04-28-2012, 05:13 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