What is the function in Microsoft Excel that lets you calculate the sum AFTER omitting the lowest and highest numbers?

MicrosoftExcel

1 answer

Answer

1076802

2026-07-25 20:20

+ Follow

Say your values were in the cells A2 to A30, then you could do a formula like this:

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

ReportLike(0ShareFavorite

Copyright © 2026 eLLeNow.com All Rights Reserved.