1. ### Using Countifs to Calculate Headcount

Hi Team, In my attached screenshot I am wondering how I can use COUNTIFS to calculate the current Headcount of employees based on the following conditions. Countif; 1. The employee class is NOT "Adecco" nor Blank. 2. The Contract Startdate is less than TODAY(todays date) and not blank. 3. The...
2. ### Simplify process for combining reports then splitting them up again

Hi guys, I'm a new member here but I've been using the forums for a while now and they've been a big help so far. I'm looking for some help with simplifying a training report I run on a regular basis. I first need to combine 3 reports with VLOOKUPs (or INDEX/MATCH) then I need to split them up...

Hi, I have data of employees from Jan 2018 to Dec 2018 and I need to calculate the Average headcount by Jan 2018 and Average headcount by Dec 2018. Is there any formula that you suggest? Thanks
4. ### Average YTD Headcount with PowerPivot/DAX

Hi Everyone, I have a fact table that is filled with multiple departments, with multiple headcount types (full time, part time, contractors, etc), spanning several years, at the MONTH LEVEL. Some of the months during the year can have 0 values as well. I am trying to write a formula that...
5. ### headcount and spend by quarter, only spend by last 4 quarters and headcount by last 1 qtr

Scenario is let's say we have customer in row, quarters in columns and spend / headcount in values. Is it possible to only show one quarter headcount while showing 4 quarter spend in the same pivot table? https://imgur.com/VM7ScsE for reference (it is not in pivot table format but gives you...
6. ### Create a Starting Number based on the Ending Number of Another Record

Hi, I am looking to create a headcount query that has 5 fields: Week #, Start Headcount, New Hire, Attrition, End Headcount I would like Week #2 Starting Headcount to = Week #1 Ending Headcount I keep running into a circular reference issue and I completely get why. If I create a Week #1...
7. ### headcount by hour spanning midnight

Hello, I am looking for a formula/method to calculate the headcount by hour of day. I have employees whose shift crosses midnight hours. e.g. employee Start End A 06:00 14:30 B 14:00 22:30 C 22:00 06:30 Now I would...
8. ### VLOOKUP (or Equivelent) based on TIME (HH:MM)

Hi all, I hope you can help me with the following; I need a formula that will look at staff Headcount, and start and finish times, and based on that.... fill out a Headcount requirement by hours. (taking the highest headcount within that hour) So, the source of the data looks like this...

I'm new to DAX and just trying to get some basic calculations running. I've looked at a number of references online (DAX Patterns, PowerPivotPro, etc...) but am unsure what I'm doing incorrectly. My data has EOQ Datestamps in a single field: 'Headcount Files'[Q_End_Date] So for example if we...

Need to create a bar chart for table having following 3 columns <tbody> Account Project# Headcount A1 2 10 A2 5 12 A3 3 8 </tbody> The bar chart need to have bars and data label for project#. Additionally on top of the Project# label it should have another label for Headcount with an...
11. ### Employee Headcount by Title over Time

Hello, I'd like to create a visual that shows change in employee headcount by title over time (e.g. change in number of Directors vs Vice President, from 2007-2017). What is the best way to show this data? Could you also include instructions with your suggestion? Thank you!
12. ### Create monthly headcount report

Hi friends, I need urgent help in creating a formula for a monthly headcount report. I am able to find a formula suitable for me in an old thread. However, for some reasons, it does not exactly fit my case and I would need help on modifying the formula. <tbody> 1 A B C D E F G H I J K L M N O...
13. ### IF formula not robust enough

Hello, I am trying to calculate headcount needed based off of volume. There is a toggle used in the calculation that I can say I need per 100 units of volume, per 200, etc. but I only went up to the toggle value times 4. I need the formula to possibly support a much larger volume such as 40...

### This Week's Hot Topics

• Use Filter function with 2 criteria to return a specific value
I've spent many hours trying to find out why the basic formula for Filter function with 2 criteria will not return a value other than #CALC. I'm...
• Loop stopping at row 10
Below is a code I had a lot of help with from user such as yourself. This code worked well but now is stopping a row 10 and I can't see why! Could...
• Numerical Order Code for Macro
I am trying to find a code or fix what i have on the macro that will automatically make the certain column generate in numerical order when I...
• Calculate time in excel
I get a text report from our time keeping system that i dump into excel through a data connection and I need to calculate the total hours for a...
• VBA
Hello everyone, I need your help please. I just need VBA code to get my reports working. What I want to do is whenever these dropdowns are...
• Help with formula to sum numbers prior to date
Hello, I was hoping to get some assistance as I'm having trouble with this. Using my table below as an example, how could I write a formula which...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back