Simple Calculation???

[coynesj]

Is there a way of summing a row of assorted numbers in excel that will omit the lowest two??

Thanks in advance.

 

[Trevor G]

You would need to look at SUM LARGE.

Take a look at this website to see if it helps.

http://www.contextures.com/xlFunctions01.html

 

[NBVC]

Assuming cells B5:H5 are of interest, try:

=SUMIF(B5:H5,">"&SMALL(B5:H5,2))