This formula also works in two ways. 1st it will look for the least three (i.e. 1, 2&3) numbers in the range of A2 to A11 and then sums up those values.
March 1, 2010
Sum of least three numbers in range of cell.
Here is another sum formula in excel which helps us to find the total for least three numbers in a list or range of cells in excel. We can use the following formula.
This formula also works in two ways. 1st it will look for the least three (i.e. 1, 2&3) numbers in the range of A2 to A11 and then sums up those values.
This formula also works in two ways. 1st it will look for the least three (i.e. 1, 2&3) numbers in the range of A2 to A11 and then sums up those values.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment