Excel 2007 -How to get the smallest value from a set of values without sorting out the data.
In the previous post, i have show how to use “SUMIF” function. I will continue use the table from previous post to show how to use SMALL function in Microsoft Excel 2007.
Normally, we are using “SORT” function to get the smallest or largest records. However, by using “SMALL” function, we do not need to do it so. Read more
Excel 2007 – How to get the SUM value in Multiple Criteria
How do I get to sum the values in a range that meet criteria that you specify?
We can use SUMIF() formula to do that. Besides, we also can use SUMIF() worksheet function for the following situations:
- When you want to return a sum for a single criteria (for example, a single IF condition)
- When you want to use multiple criteria and return the sum to multiple cells
Syntax:
SUMIF(range, criteria, [sum_range])
Font size become small when click “reply” in outlook 2007
One of my user ask me this question “Why is the font size small when clicking “reply” in outlook 2007”
When she click the reply button, the original message is about 10 times smaller than the original text.
