Excel Formula Required

  gizzyx 20:03 31 Mar 03
Locked

i need a formula for a spreadsheet that will sum a column of figures, but ignoring the smallest two figures. could any of you fine chaps help me out?

  MAJ 21:04 31 Mar 03

If the cells to be calculated are in the range A1 to A14, try this, gizzyx.


=SUM(A1:A14)-SMALL(A1:A14,1)-SMALL(A1:A14,2)

Am I right, VoG™?

Well done Maj

  MAJ 21:35 31 Mar 03

Thanks Whisperer, and it only took me 40 minutes. Right, time to hide from VoG™.

  gizzyx 22:27 31 Mar 03

Thanx, Maj. just the job!

This thread is now locked and can not be replied to.

LG G6 review: Hands-on with LG’s bold, big-screen shot at perfection

1995-2015: How technology has changed the world in 20 years

How the 2017 Oscar-winning VFX of The Jungle Book were created

The 22 best Safari extensions | Best Safari plugins: Improve Apple's Safari web browser with these…