#1
|
|||
|
|||
Counting totals within month period
Hi all,
Im struggling to get my head around how to tally the number of employees within a month by month period (its too early and I haven't had enough coffee) calculating leavers also. I've attached my current workings which almost works and Im just wondering if I am trying to make it too complicated. I want to be able to show the total number of employees within each month indicating what the count is for that month and going forward - please help |
#2
|
||||
|
||||
Why not use a simple Pivot Table?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
haha you say simple pivot table - I'm useless at Excel, looked up pivot table and gave up
Any help would be appreciated. |
#4
|
|||
|
|||
I din't understand exactly, what you need to calculate, so on sheet Report are some different choices available.
I started with sheet EmplCalendary, but at end was it not needed. I didn't delete the sheet, and some Dynamic Ranges I created - maybe you find some use for them. |
#5
|
|||
|
|||
Quote:
Again it made me laugh when you say a simple pivot table as your example wasn't simple Thanks again |
#6
|
||||
|
||||
Well, if the free help you get here is laughable, you should consider other options...
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Stuck! How do group these ranges with totals? | mrdeflok | Excel | 1 | 06-13-2017 07:52 PM |
Counting unique visitors by ward, counting monthly visits by status, editing existing workbook | JaxV | Excel | 9 | 11-14-2014 12:25 AM |
Count the common time period (month) between two date period of time | Barni | Excel | 6 | 08-15-2014 07:52 AM |
Range Lookup for Totals? Confused | lawnG | Excel | 1 | 02-01-2011 10:42 AM |
Please help with Sum formula to add totals by State! asap | dutch4fire23 | Excel | 0 | 07-28-2006 12:41 PM |