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: