Hi,
I have a very large spreadsheet where I need to find the minimum of each row between 2 columns and then sum those minimums. Basically I want to do the following: sum (min(a1,b1),min(a2,b2)....min(an,bn)). I don't want to add a column that calculates the individual minimums because of the size of the spreadsheet. Any suggestions?
For just 2 columns try this "array formula"
=SUM(IF(A1:A100<B1:B100,A1:A100,B1:B100))
confirm with CTRL+SHIFT+ENTER
adjust number of rows as required
Audere est facere
A non-array formula perhaps..
=SUMPRODUCT(SUBTOTAL(5,OFFSET(A1:B100,ROW(A1:B100)-ROW(A1),0,1)))
Life's a spreadsheet, Excel!
Say thanks, Click *
Both formulas work!!! Thanks!!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks