Ok here is some of my data attached. The tab called 'Master Data' has part of the original dataset. The formulas I am using are located at X2:AE16.

I am using these formulas to populate areas in the tab 'Summary data Panels'. I have populated this spreadsheet once before but had to go back and edit the 'Master Data' so I am currently editing what is already there. The data that I have already edited is highlighted in orange. What is attached is just a small section of my dataset as it is too large to be attached. Column AH has the data range info for each panel I am wanting to summarise .

Attached Files

Flaking data.xlsx (426.1 KB, 9 views)