CODEWITHSUNDEEP
google-sheetssumgoogle-sheets-formula
Johnny Eaton
Johnny Eaton

Reputation: 1

Google Sheets: Find minimum sum in an ordered array

My goal is to find the smallest sum of 1 entry per column in this array.

i.e. Though column 9 has the lowest value for all rows, only one value can be used, and same for all the other columns, and I want to know what combination will produce the smallest sum.

Is there any way of doing this in Google Sheets?

Thank you!

image sample

Upvotes: 0

Views: 121

Answers (1)

Osm
Osm

Reputation: 2891

Use this formula

=INDEX(QUERY({A3:I},"Select "&
       TEXTJOIN(", ",1,ARRAYFORMULA("min(Col"&COLUMN(A3:I)&")"))),2)

enter image description here

Upvotes: 0

Related Questions