Hi,
I'm creating an overview of data related to attendance
I'd like to create a spread (see picture below) that will update itself automatically as and when new data has been added to the original worksheet. It's an annual overview, but I'm stuck on the formula.
Where the information will be displayed:
Overview.PNG
Where the information is kept that will be used for the Overview:
Raw Data to use.PNG
I currently have this code in cell B3:
But I've just noticed this isn't the function I need. I want the total amount of times somebody was absent, sick, on holiday etc, per month. I need a SUMIFS formula but not 100% confident it's the easiest way - I'm using this as a database where I add the information via a userform which adds data to the next available row, so I'm a bit confused as to how to select the range to use. I know there's a way that I can use the VBA to rename the range after it adds data but I'm so newbie I'm figuring out things as I go.
My attempts @ SUMIFS
Bookmarks