The process of manually counting values in Excel is time-consuming and error-prone, especially when you have a lot of data. Fortunately, there are a few automated ways to count values. From the questions we get from our customers about counting, it's clear that not everyone knows how to go about it. There are different methods, depending on what you want to count. For a simple value count, I just select the range of cells that contains those values,
Office 2007, and then I look in the status bar. Or,
Office 2010 Professional Plus, if my data is in an Excel table format, I can quickly get a value count in the Total row. But to keep track of a value count on the worksheet,
Office 2007 Key, I use the COUNT function, which counts the number of cells that contain values, and then specify one or more ranges that contain the values within the parentheses. The function then returns the number of values and displays it in the worksheet. How easy is that? To see it in action,
Microsoft Office 2007 Product Key, check out this video. To learn more about this function and other ways you can count in Excel, see COUNT function and Ways to count values in a worksheet. Don't let the fact that COUNT is a function intimidate you-it's really simple to use,
Microsoft Office Enterprise 2007, and once you know it, you'll never go back to counting by hand. If you already know about the COUNT function and use it on a regular basis, do you have any tips to share? We'd love to hear more about how people are using this function. --Frederique Klitgaard <div