Summarize array data

[tana]

Hi,

Can I have help on a situation which involves with array data?

I have the following categories to summarize (some may have cost data, some may not):

C20288 High Voltage Switch Replacements 202411.xlsx
	X
3	Project Management & Administrative
4	Internal Engineering
5	External Engineering
6	Construction Labour
7	Construction Equipment
8	Construction Services
9	Materials
10	Contingency
11	Allowance
Input

Then I have these cost data in an array:

C20288 High Voltage Switch Replacements 202411.xlsx
	X	Y
16	Project Management & Administrative	500
17	Internal Engineering	500
18	External Engineering	33000
19	Project Management & Administrative	1750
20	Internal Engineering	1750
21	External Engineering	58000
22	Construction Labour	1100
23	Construction Equipment	200
24	Construction Services	0
25	Materials	142000
26	Project Management & Administrative	600
27	Internal Engineering	500
28	External Engineering	28000
29	Project Management & Administrative	500
30	Internal Engineering	500
31	External Engineering	0
32	Project Management & Administrative	520
33	Internal Engineering	500
34	External Engineering	19731.51
35	Project Management & Administrative	700
36	Internal Engineering	500
37	External Engineering	19326.79
38	Project Management & Administrative	680
39	Internal Engineering	500
40	External Engineering	22285.26
41	Project Management & Administrative	630
42	Internal Engineering	500
Input

Cell Formulas
Range	Formula
X16:Y42	X16	=CHOOSECOLS(R3#,2,3)
Dynamic array formulas.

I would like to have spilled formula which can summarize by category. Thanks!

 

[tana]

You don't need to drag the formula, it's a spill range. Just change the value of the last row well below your expected data.

Thanks,