MIN Value of two summed columns - Array ??

[shaunwilko]

I am pretty familiar with array formulas and all general formulas and consider myself to be pretty competent but this one has me stumped.
Throwing out there to see if there are any brains out there that know how I might write a formula for the following.

Column A
R1 - 5
R2 - 4
R3 - 3
R4 - 2
R5 - 3
R6 - Blank Row
R7 - 4

Column B
R1 - 6
R2 - 7
R3 - 8
R4 - 9
R5 - 0
R6 - Blank Row
R7 - 4

In a formula on another page I want to add together columns A and B, and then take the minimum of those additions.
So in the case above the minimum value I am after would be 3.
This is because on R5 3+0 = 3 which is the lowest number of the additions.
I do not want to add a sum column in the source table and then take the minimum of that as I dont have great access to the source table.
Inside my formula I need to add them then using the min function grab the minimum value of them all.

I have tried many combinations of the MIN, SUM both in Array functions and not in array functions but cannot nail it.
Getting the minimum of 1 column is easy - I am finding getting the minimum of the addition of two very difficult.

Any suggestions ?

I should add that there can sometimes be 8 records, sometimes 10 records.
So the formula needs to be written to ignore blank cells, but include cells containing 0.

Thanks in advance for any time taken to read or consider my query!

[benishiryo]

welcome to the forum shaunwilko. maybe:
=MIN(IF(A1:B10<>"",A1:A10+B1:B10))

do upload a sample excel file next time. it'll be easier for us. To upload, Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
and to illustrate your example better, click on How To Get Quick & Good Answers

Edit: forgot to mention it's an array formula

[AlKey]

Hi and welcome to the forum,


The problem will only occur if both cells on the same row are empty.

You can use any these two formulas

=SUMPRODUCT(MIN(B2:B8+C2:C8))

or

An array formula

=MIN(B2:B8+C2:C8))

	A	B	C	D	E
1					Min Value
2	R1	5	6		3
3	R2	4	7
4	R3	3	8
5	R4	2	9
6	R5	3	0
7	R6	10
8	R7	0	4

[shaunwilko]

Wow talk about a quick response !

{=MIN(IF(A1:B10<>"",A1:A10+B1:B10))}

This worked on my sample test worksheet i described so will try on the real thing now.
And thanks for the heads up on the attaching of the sample sheet.
Ill be sure to remember next time.