Microsoft Office Tutorials and References
In Depth Information
Figure 14-14: The goal is to count the number of characters in a range of text.
The array formula is then reduced to the following:
Summing the three smallest values in a range
If you have values in a range named Data , you can determine the smallest value by using the SMALL function:
You can determine the second smallest and third smallest values by using these formulas:
To add the three smallest values, you could use a formula like this:
=SUM(SMALL(Data,1), SMALL(Data,2), SMALL(Data,3)
Search JabSto ::

Custom Search