Excel Formula Required

  gizzyx 20:03 31 Mar 2003
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 2003

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 2003

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

  gizzyx 22:27 31 Mar 2003

Thanx, Maj. just the job!

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

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Converse draws on iconic heritage for a fresh brand identity

Mac power user tips and hidden tricks

Comment lancer Windows 10 en mode sans échec ?