Looking for the best way to aggregate data in a data set that meet certain criteria.

[vharp91]

I am looking for the best way to aggregate data in a data set that meet certain criteria. In the below data set, I would like to aggregate (sum up) the actual dollars (column G), given that the account number (column F), the start/end date (columns D&E), the department ID (column C), and the entity ID (column B), and the Corporation ID (column A) match. So in the below data set, rows 4 & 5 would be aggregated as well as rows 1 & 2. I would like the data to remain in this format, I just need to aggregate those rows up so that the actual dollars are summed up if they meet that criteria and now the data is displayed in one row.

 

[awoohaw]

try this:

mr excel questions 5.xlsm
	A	B	C	D	E	F	G
10	Corp ID	Entity	Dept ID	SDate	Edate	AcctNbr
11	CA2019	CA2018	267500	10/01/2022	10/31/2022	600000	98287.33
12	CA2019	CA2018	267500	10/01/2022	10/31/2022	610000	63049.02
13	CA2019	CA2020	346560	11/01/2022	11/30/2022	612201	3081.7
14
Sheet6

Cell Formulas
Range	Formula
G11:G13	G11	=SUMPRODUCT((--(A11=$A$3:$A$7)),(--(B11=$B$3:$B$7)),(--(C11=$C$3:$C$7)),(--(D11=$D$3:$D$7)),(--(E11=$E$3:$E$7)),(--(F11=$F$3:$F$7)),($G$3:$G$7))