Conditional formatting (Colour Scales) across a range of cells

Gethin 

In the attached I've assembled a very cursory example of how a single raw data base can be summarized in a pivot table to show the total counts of trips, doses (wasn't clear what you were doing with hours and minutes). I only did three people (on the assumption that each of your nine summaries represented a different service provider) and three months (enough to illustrate) rather than twelve.

The Pivot Table--which is what this output is--is almost automatic. No formulas need be written at all. The Pivot Table facility is designed so that it summarizes total counts (of the trips) or sums (of the total dosages in this case)....and it can do much more. It's widely regarded as one of the most useful kinds of basic outputs and it works wonders with raw data input.

This is not the exact layout you have, but that could be done as well. My point is simply to show how a single database can serve as the basis for a detailed analytical report. It's a lot more flexible if you separate the raw data (Input) end of things from the reporting or Output end. Excel has amazing abilities to summarize data. When we "manually" get in the way by artificially breaking it apart to early--and then want the kind of cross table analysis you're asking for--we actually make it harder to get there.

This happens because we often approach the spreadsheet thinking of the paper printout we want at the end, and design things according to that desired end product. Instead, it usually is helpful to think first of the data you want to summarize, just in terms of the data itself: how can it be collected, at what level of granularity, to then serve, when we have all the data, as the basis for a variety of comparative reports, trend analyses, and so forth.