I get data as a download and have been asked to produce a report that gives a number of variations to stats that are required.

What is required is to summarize the data on a summary sheet, I have attached an extract of the download and then a layout of the spreadsheet in the way they want it, but am stuck on the starting point and what formula's to use etc for the summary sheet.

I have looked at countif against the branch and policy count, but can't get further than that, I am not sure of the formulas to use or if VBA would be a better option and if so I have no concept at this time where to begin

If someone could look and make suggestions/guide me I would be very grateful.

I have finally completed this task. With a number of formula and adjustments to the download I can now look to automate the process.

A sample of the completed spreadsheet is attached in case anyone else has something similar to do.

If there are any wonderful VBA experts that would look at what I have done and see if automation can take place that would be very very useful