Remove 2 Lowest Numbers from a Sum of Numbers in Non-Consecutive Cells

[thebrtnder]

I cannot figure a way to remove the two lowest numbers from this sum of cells
For the lowest number I use the MIN function like this:
SUM(B6,B10,B14,B18,B22,B26,B30,B34)-MIN(B6,B10,B14,B18,B22,B26,B30,B34)
I dont believe the SMALL function works since the group of cells is not an array, so I am lost...

 

[AhoyNC]

Welcome to the forum.
Try:
=SUM(B6,B10,B14,B18,B22,B26,B30,B34)-SUM(SMALL((B6,B10,B14,B18,B22,B26,B30,B34),{1,2}))

 

[thebrtnder]

Welcome to the forum.
Try:
=SUM(B6,B10,B14,B18,B22,B26,B30,B34)-SUM(SMALL((B6,B10,B14,B18,B22,B26,B30,B34),{1,2}))

Worked perfectly - thanks so much!!! So apparently an array can be created by putting the calls into parentheses - good to know!!! That was what I really couldn’t figure out… thanks again!

 

[Peter_SSs]

Worked perfectly - thanks so much!!!

Welcome to the MrExcel board!
The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.

BTW, if you have all the new functions available in your 365 version, another option might be as shown in E6 below.

23 04 21.xlsm
	B	C	D	E
6	3		13	13
7	5
8	6
9	0
10	2
11	6
12	5
13	3
14	1
15	1
16	4
17	7
18	2
19	5
20	6
21	4
22	2
23	3
24	5
25	6
26	2
27	5
28	4
29	6
30	2
31	0
32	1
33	3
34	2
Sum less 2

Cell Formulas
Range	Formula
D6	D6	=SUM(B6,B10,B14,B18,B22,B26,B30,B34)-SUM(SMALL((B6,B10,B14,B18,B22,B26,B30,B34),{1,2}))
E6	E6	=SUM(DROP(SORT(CHOOSEROWS(B6:B34,SEQUENCE(8,,,4))),2))