Viewers: in countries Watching now:
Numbers offers intuitive organization features, allowing users to focus more on analysis and presentation. In Numbers '09 Essential Training, David Rivers explores the important features of this spreadsheet application and introduces the new tools for formula development and charting. He walks through the new functionality of charts, tables, and templates, and shows how to make spreadsheets effective and eye-catching. Exercise files accompany the course.
Although we can type functions ourselves into the Formula Editor or Formula Bar, the new Function Browser offers a convenient and helpful way to add a function to a formula. Let's use our Energy Saving Plan spreadsheet. On the Energy Saver sheet we have two tables. The second table titled Count by Yearly Savings is going to count the number of energy savers based on yearly savings amounts. So the first step is to select the cell where we want to enter the formula. In this case, cell C2 of our Count by Yearly Savings table.
Now to insert the function, we'll use the Function Browser. We can access it a number of different ways from the View menu or from the Toolbar, click the Function button and choose Show Function Browser. This opens up the Function Browser in its own window, this window can be moved around. It can be resized to display more or less information. On the left-hand side you will see the different Function categories, you can choose from. And on the right-hand side, the various functions that exist in those categories. We know we need to count the number of cells containing value.
So let's go to Statistical on the left-hand side to see a list of actual functions that exist in the Statistical category. As we scroll down, you will notice a number of Count options. If we click the first one called COUNT, we get a description down below, a definition. As we scroll down through this information, we are going to see how we can use this formula, Usage Notes, a number of Examples on how we might use this and down below Related Topics as well.
So we can get help directly from the Function Browser. Well as we scroll up and read about the Count Function, we realize this won't allow us to use both in array and a condition. So if we click COUNTIF, we get a definition for that Function and this appears to be the one we want, where we get to use a condition. Now to insert this function, we can double-click it or with it selected already, click Insert Function. Notice it gets inserted into the cell, the Formula Editor appears, also we see this information on the Formula Bar. Now it's a matter of replacing those placeholders. We'll start with test- array. When we select it, it's highlighted and as we leave our mouse over the test -array placeholder, we'll see a little bit of information.
The collection containing the values to be tested. Well in that case, we want to select the range of cells in our List of Energy Savers table. Let's move the Function Browser out of the way, so we can see the Yearly Savings, we'll select all of those cells and they get placed into the Placeholder. We are ready to move on to the Condition now. Click the Condition Placeholder to select it. If you wish, you can hover over that Placeholder to view a little information about the condition. In this case, our condition is going to be based on the dollar amounts from $0-100.
In other words, less than or equal to 100. So we'll type that in double quotes. We know that by viewing the information in our Function Browser that we need to place this between double quotes. Check out some of the examples down below. So with Condition selected, we'll type in the first "<=100" and we are ready to accept this formula. When we click the Accept button, notice the answer is 13.
When you are done with the Function Browser, you can close it the same way you opened it or click the Close button in the top left corner. And now we would continue entering COUNTIF functions for the remaining cells in this table. But let's deselect the table by clicking the canvas. Without the Function Browser we may have experienced difficulty getting this formula written. So use the Function Browser whenever you need assistance using the many functions available in Numbers '09.
There are currently no FAQs about Numbers '09 Essential Training.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.