More Excel Questions

[bertusgeert 1]

I have a range of data and I want to remove the TWO BIGGEST and TWO SMALLEST numbers in the column, then take the sum the column.

=SUM(A1:A30)-MAX(A1:A30)-MIN(A1:A30)

naturally only takes the biggest one and smallest one
out.

How do I get the biggest two and the smallest two out of there?

---------------------------------------------
As jy dom is moet jy bloei!

[TheBachelor 5]

You could do something like this:
=SUM(A1:A30)-MAX(A1:A30)-MIN(A1:A30)-LARGE(A1:A30,2)-LARGE(A1:A30,COUNT(A1:A30)-1)

You can also change your MIN/MAX to use LARGE, but MIN/MAX is more readable.

There are battered women? I've been eating 'em plain all of these years...