I've filtered and sorted a worksheet so that it has multiple areas of data, the data is always in columns "A:P". The grouping of areas will have a different number of rows but there is always two blank rows in-between the areas. Then I made the macro add the sum of each area in column "D"...