How to use Arrays in Functions like LARGE / Conditional Range

[masterton]

Please take a look at the spreadsheet.

1. I have two arrays (array formula 1 & 2).
And a large function which references the two arrays.
=LARGE(I4:I5, 2)

It does not work at all.
What should I do?

2. I want to calculate the sum of each section.
The name "Check" or "Verify" acts like a separator to draw the border of each section (see the spreadsheet).
Number of entries inside each section are not constant!

xxx }
xxx }
xxx }-- Add all numbers
Check ]
xxx ]
xxx ]
xxx ]
xxx ]-- Add all numbers
Verify }
xxx }
xxx }-- Add all numbers

The actual data is very long, so I need a way to define the range of each section by functions.
What should I do?

 

[Peter_SSs]

Is this what you mean?
Formula in F4 is copied down.

Excel Workbook
	D	E	F
3	Project	Budget	Sum
4	AA	200	200
5	Check	123
6	CC	452	575
7	Verify	648
8	EE	250
9	FF	348
10	GG	294	1540
11	Check	830
12	II	580
13	JJ	326
14	KK	500
15	LL	380	2616
16	Check	120
17	NN	465	585
18
Sum