How to use Arrays in Functions like LARGE / Conditional Range

[mastertonn]

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?

[sktneer]

Try this Array Formula. Array Formula requires special key strokes Ctrl+Shift+Enter instead of just Enter which you normally use in case of normal excel formula.

In F5

Please Login or Register  to view this content.

and then copy down.

Is this what you are trying to achieve?

[mastertonn]

Try this Array Formula. Array Formula requires special key strokes Ctrl+Shift+Enter instead of just Enter which you normally use in case of normal excel formula.

In F5

Please Login or Register  to view this content.

and then copy down.

Is this what you are trying to achieve?

Thanks a lot for your answer.

Yes close to it, but Row 4 has been missed out which is the start of the data table.

I'm just trying to get what the formula does. :/