Hi All,
I am new to the forum for posting, but have found many useful posts here in the past, it's a great resource. I have a question, which at present I am not able to find the answer for.
I have a table that gathers it's data via a query, from a database, every 30 minutes.
Within the table are details of jobs that have been logged on a job system today, with their corresponding status code.
I can COUNTIF the Status ID column to give me the total number of jobs with any given status at anytime.
But what I really need to do is be able to take a daily total for each status type at the end of the day, and record this data in a separate table, once a day, say at 23:00hrs each day.
There is an example of the data in the file here: https://www.dropbox.com/s/jiofwec9y2...mple.xlsx?dl=0
A is the data
B is the totals at any given time I look at the spreadsheet
C is the table I would like to be populated at the end of every day, so I always have the final totals for that day at any point in the future
Any help is much appreciated as I am by no means an advanced user.
Thank you
Bookmarks