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