Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need help setting up a formula to look at a range of data (will vary
between 4, 5, or 6 values), choose the 4 highest values and add them together (ignoring the rest). ie. b1 = 25 b2 = 18 b3 = 21 b4 = 23 b5 = 22 b6 = 25 Total = 95 (ignoring 18 & 21) or: b1 = 25 b2 = 18 b3 = 21 b4 = 23 b5 = 22 Total = 91 (ignoring 18) Thanks! |