Spreadsheet query

  Gary Wood 16:33 23 Apr 2009

I have a spreadsheet of data. I want to put a formula in a column to give me the total of the four highest values in the five preceding cells.

For example (letters are columns):
A=5, B=2, C=6, D=3, E=4

Then column F should = A+C+D+E = 18

But, in the next row, the lowest value might be in column C, in which case, it should be excluded where all the others are totalled.

I hope this makes sense and that someone can tell me the correct formula.

Many thanks,


  VoG II 17:00 23 Apr 2009

There might be a more elegant formula but try


  Gary Wood 17:07 23 Apr 2009

Thanks, VoG™.

I'd just found the LARGE function online when you posted back! With what you posted and what I read, I came up with:


Which does exactly what yours did, I think, but is just a bit shorter.

Thanks very much for your help.


  VoG II 17:08 23 Apr 2009

There might be a more elegant formula...


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

Elsewhere on IDG sites

OnePlus 5T review: Hands-on

Illustrator Andrés Lozano on his improv line work, brazen use of colours & hand sketching

iPhone X review

Comment envoyer gratuitement des gros fichiers ?