Dear all,
I have one row that have around 100 numbers and I would like to sum only the first 3 minimum numbers.
Could anyone can help me?
Thanks a lot!
Nam
Dear all,
I have one row that have around 100 numbers and I would like to sum only the first 3 minimum numbers.
Could anyone can help me?
Thanks a lot!
Nam
try this =SMALL(A1:F1,1)+SMALL(A1:F1,2)+SMALL(A1:F1,3)
or
=SUMPRODUCT(--(SMALL(A1:F1,{1,2,3})))
Easier to modify if you want 4th or 5th as well
e.g
=SUMPRODUCT(--(SMALL(A1:F1,{1,2,3,4,5})))
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks