SUM rows based on multiple criteria and insert below

[sjk1193]

So what i need to do is sum the values in the Units and amount columns if :
- the person is the same
- "x" starting number of characters is same in the desc column (ex. one__ or three____)
- the Cur being "U"

Then i need to insert a new BOLDED row underneath each change in colour in the rows with the sums of the units and amount columns

group	Person	Desc	Cur	xx	Units	xx	amount
111	abc	one - 1	U	xx	531	xx	35146
111	abc	one - 23	U	xx	785	xx	584684
111	abc	one - 4	U	xx	9	xx	4125
222	def	one - 1	U	xx	-65	xx	452
222	def	one - 23	U	xx	45	xx	-52
222	def	one - 4	U	xx	41	xx	852
333	hij	three- 9	U	xx	-546	xx	452
333	hij	three - 4	U	xx	254	xx	45
444	klm	two - 9	U	xx	-2	xx	2263
444	klm	two - 4	U	xx	45	xx	-35
444	klm	two- 6	C	xx	345	xx	4587
444	klm	two - 8	C	xx	35	xx	753

<tbody>
</tbody>

so after it would kind of look like it looks for the brown rows for all of the colours

group	Person	Desc	Cur	xx	Units	xx	amount
111	abc	one - 1	U	xx	531	xx	35146
111	abc	one - 23	U	xx	785	xx	584684
111	abc	one - 4	U	xx	9	xx	4125
111	abc				1325		623955
222	def	one - 1	U	xx	-65	xx	452
222	def	one - 23	U	xx	45	xx	52
222	def	one - 4	U	xx	41	xx	852
333	hij	three- 9	U	xx	-546	xx	452
333	hij	three - 4	U	xx	254	xx	45
444	klm	two - 9	U	xx	-2	xx	2263
444	klm	two - 4	U	xx	45	xx	35
444	klm	two- 6	C	xx	345	xx	4587
444	klm	two - 8	C	xx	35	xx	753

<tbody>
</tbody>

 

[Johnny Thunder]

Why not just make a pivot table? You could get the desired result for all the columns that have the matching criteria you are explaining in your question.

 

[sjk1193]

I think your right, I've been thinking to complex

 

[Johnny Thunder]

It's fine. We've all done it before. Sometimes over engineering a solution that Excel can already handle with Pivots or other means.

If the data set grows one approach for automation with a macro could be for you to give your pivot source data a named range so that you can control that aspect with a macro that redefines the last row as the report grows.