Microsoft Office Tutorials and References
In Depth Information
Chapter 19: Ten Functions You Really Should Know
Chapter 19
Ten Functions You Really
Should Know
In This Chapter
Summing, averaging, and counting
Rounding numbers
Using IF for conditional results
Using the current date and time
Determining whether a value is a number
Finding the smallest and largest values
Using conditional summing and counting
This chapter lists the top ten Excel functions. Actually, it lists the top 15,
but in some cases two related functions are treated as a single item. To
be fair, there is no absolute top ten list of functions, but over the years (don’t
ask how many!) I have worked on hundreds of worksheets and saw some of
the same functions used all the time.
The functions in this list are of the type that apply to a wide array of needs.
You won’t see a financial function or any advanced statistical function — just
the basics — but knowing the functions in this chapter is essential to good
Excel work. You can always refer here for a quick brush-up on how to use
these important functions.
SUM
Adding numbers is one of the most basic mathematical operations. And so
there is the SUM function dedicated to doing just that. SUM takes up to 255
arguments.
Each argument can be a single number or a range containing multiple numbers.
That means SUM can add up a whole bunch of numbers! The syntax follows:
Search JabSto ::




Custom Search