# A formula to directly calculate the minimum sum without borrowing auxiliary columns

1. ## A formula to directly calculate the minimum sum without borrowing auxiliary columns

Is there a formula to directly calculate the minimum sum without borrowing auxiliary columns ?

Auxiliary columns D2:E5

E7 final result directly calculate

Any help would be appreciated! TQ

2. ## Re: A formula to directly calculate the minimum sum without borrowing auxiliary columns

Deleted by JT

3. ## Re: A formula to directly calculate the minimum sum without borrowing auxiliary columns

=SUM(MOD(SMALL(IF(TRANSPOSE(A2:A8)=A2:A8,TRANSPOSE(B2:B8),10^6)+ROW(A2:A8)*10^6,(ROW(A2:A8)-ROW(A2))*ROWS(A2:A8)+1)*(MATCH(A2:A8,A2:A8,)=ROW(A2:A8)-ROW(A1)),10^6))

Ctrl+Shift+Enter

and easier with MS365

=SUM(MINIFS(B2:B8,A2:A8,UNIQUE(A2:A8)))

post deleted

5. ## Re: A formula to directly calculate the minimum sum without borrowing auxiliary columns

E7 cell array formula

HTML Code:

6. ## Re: A formula to directly calculate the minimum sum without borrowing auxiliary columns

@Bo_Ry and @wk9128
Excellent solution. Thank you both, thank you very much for the solution.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1