Counting totals within month period

shabbaranks · #5 09-19-2018, 05:58 AM

Quote:

Originally Posted by ArviLaanemets

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.

Thanks - looks exactly what I need. I've just created another page to create my own pivot using your methods (as I want to try and understand how it works).

Again it made me laugh when you say a simple pivot table as your example wasn't simple

Thanks again

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