Calculating value less minimum numbers in the sequence

G

Guest

I am trying to find a function that will add a series of numbers LESS the 2
lowest numbers in the seqeunce. They are not in order from lowest to smallest
as there is more than one group and it is sorted by date.

Example:

172 172 172 180 169 180 163 180 175 165 180 175 180

I would need it to pull out the 163 & 165 and add the rest. These numbers
will be different for each row and the lowest are not always in the same
column. Any ideas??

thanks!

Karen
 
R

Rick Rothstein \(MVP - VB\)

This formula should do what you want...

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

Rick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to subtract the two lowest values from a row of numbers 4
LOOKUP VALUE OCCURS >ONCE IN TABLE ARRAY - RETURN LAST OCCURRENCE 6
SumProduct & Index functions 1
How do I: Extract column headers based on lowest number in sequence 2
Find the lowest4 numbers of the last 6 in a range 8
using two functions in the same cell 6
Find Missing Numbers in a Sequence 3
Finding the lowest price in a row 13

Top