Find minimum SUM if no minimum number in row

I want in A1 to find minimum SUM if no minimum number in row.

Here is example attached:

Book1.xls

How it is? i thought minimum number always exist. For example u have thousand and thousand numbers, can't u get min number amogst them?

think I understand

try this one

Please Login or Register  to view this content.

EDIT

I REALLY SAW AFTER POSTING

Very funny
Thank for greeting

In testing the formula by ContaminatedWithExcel there are instances where it returns a result although the minimum number is in the same row as the result. Not what zbor is looking for.

I admit it's not a pretty formula given the use of volatile functions , but it seems to be working as far as I can tell. I resorted to the use of helper cells, of which the formulas you may want to consolidate into a single formula.

=IF(OFFSET(INDIRECT(ADDRESS(MATCH(MIN($L$3:$L$12),$L$3:$L$12,0)+2,12)),0,4,1,1)=FALSE,SMALL($L$3:$L$12,1),SMALL($L$3:$L$12,2))

EDIT: After further testing (repeatedly forcing recalculation), my solution also returns an occasional incorrect result, albeit much fewer instances.

Hey zbor, I like the hidden message.......

You can use this array formula

=MIN(IF(COUNTIF(OFFSET(C3:K3,ROW(C3:K12)-ROW(C3),0),M3),"",L3:L12))

...or this one.....

=MIN(IF(MMULT((C3:K12=M3)+0,TRANSPOSE((COLUMN(C3:K3)>1)+0))=0,L3:L12))