+ Reply to Thread
Results 1 to 4 of 4

SUMIFS Query: Trying to create a headcount report

  1. #1
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2019 H: 365
    Posts
    940

    SUMIFS Query: Trying to create a headcount report

    Hi,

    I'm trying to create a report that shows the headcount by department on a monthly basis. The problem I'm encountering is that it doesn't include people in the calculation if they don't have an end date, i.e. they are permanent staff. I'd be grateful if someone could review the attached example and let me know how to amend or write a new formula that does what i'm trying to achieve?

    If you have any queries just give me a shout.

    Thanks in advance,

    Snook
    Attached Files Attached Files
    Last edited by The_Snook; 08-02-2015 at 02:11 PM.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: SUMIFS Query: Trying to create a headcount report

    Hi,

    Perhaps a Pivot Table of your data with grouped dates would help? See the attached.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: SUMIFS Query: Trying to create a headcount report

    How about another try?

    Put this in I4 and pull it across and down.

    =SUMIFS(Headcount,Dept,$H4,Start_Date,"<="&I$2,End_Date,">"&I$2)+SUMIFS(Headcount,Dept,$H4,Start_Date,"<="&I$2,End_Date,"")

  4. #4
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2019 H: 365
    Posts
    940

    Re: SUMIFS Query: Trying to create a headcount report

    I think you've nailed it mate, cheers!

+ 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. sumifs query
    By bzl in forum Excel General
    Replies: 3
    Last Post: 06-05-2015, 08:18 AM
  2. [SOLVED] Sumifs Query
    By sats43 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-14-2014, 08:42 AM
  3. [SOLVED] Excel - INDEX, MATCH, SUMIFS?! TIME & ATTENDANCE REPORT
    By ccernat in forum Excel General
    Replies: 12
    Last Post: 08-20-2013, 04:57 AM
  4. Replies: 1
    Last Post: 07-17-2013, 11:34 AM
  5. Replies: 3
    Last Post: 01-20-2012, 12:02 PM
  6. Replies: 2
    Last Post: 06-29-2011, 04:35 PM
  7. Need advice on how to create a headcount adds/reductions report
    By som3on3_10 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-04-2011, 10:18 AM

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