How to use Arrays in Functions like LARGE / Conditional Range

masterton

New Member
Joined
Jul 16, 2014
Messages
14
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?
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
Is this what you mean?
Formula in F4 is copied down.

Excel Workbook
DEF
3ProjectBudgetSum
4AA200200
5Check123
6CC452575
7Verify648
8EE250
9FF348
10GG2941540
11Check830
12II580
13JJ326
14KK500
15LL3802616
16Check120
17NN465585
18
Sum
 
Upvote 0

Forum statistics

Threads
1,226,730
Messages
6,192,708
Members
453,748
Latest member
akhtarf3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top