Formula to show sum of each group

[ShadowLady17]

Hi, I'm trying to do a formula to show the totals of each group based on different criteria that could possibly change.

For example, with the below data I'd want in a separate spreadsheet showing the two subtotals (342.88, 138.28 etc) but these subtotals are based on column B(4141, 4142 etc) but they won't always be that, next month they could be 4132 or something so I can't reference the specific ones shown.

ccc	4141	ccc	6.99​
		ccc	40​
		ccc	7.5​
		ccc	79.96​
		ccc	8.6​
		ccc	55.9​
		ccc	34.98​
		ccc	69.96​
		ccc	38.99​
	4141 Total	342.88​
	4142	ccc	5.7​
		ccc	5.18​
		ccc	50​
		ccc	64.5​
		ccc	12.9​
	4142 Total	138.28​

mmm	4116	mmm	299​
		mmm	100​
		mmm	100.94​
	4116 Total	499.94​

So I'd want the worksheet to look like this:

30.10.2022​	200230	4141				342.88​	ccc	1210	ACCGAGJ_GPC
30.10.2022​	200230	4142				138.28​	ccc	1210	ACCGAGJ_GPC

30.10.2022​

200230

4116

499.94​

mmm

1210

ACCGAGJ_GPC

But column C won't always be that specific number, so I need to sum the total based on column H (cccc....) and C but C will have changing criteria.

 

[alansidman]

You have data that is in the mocked up solution that is not in the source data. How do you expect us to figure those items out? Give us a realistic source data. Please use XL2BB to upload your data.