Need to count the cells in a worksheet range that contain data averages? Microsoft Excel supplies several easy-to-use functions for just such a purpose says bestselling computer book author Stephen L. Nelson
If you select a range of cells, you can have Excel find how many cells are in that range using the count functions. This sounds a little goofy, but a handful of easy-to-understand examples show how this works--and suggest when you might want to use the "cell counting" functions.
COUNT
To find the number of cells in a range that contain numbers (or dates, or textual representations of numbers), you use the COUNT function. This function does not count cells containing text or logical values like TRUE and FALSE, nor does it count empty cells.
The COUNT function uses the following syntax:
=COUNT (data set range)
For example, if you have a database of 100 customer survey responses, and column C contains numeric responses to the question if a customer chose to respond, you can find out how many people answered the question using the COUNT function.
COUNTA
The COUNTA function counts all cells in a range that aren’t empty, including cells with error values, logical values, and text.
The COUNTA function uses the following syntax:
=COUNTA(data set range)
COUNTBLANK
The COUNTBLANK function counts only blank cells.
The COUNTBLANK function uses the following syntax:
=COUNTBLANK (data set range)
COUNTIF
The COUNTIF function counts the cells that fit the criteria you specify.
The COUNTIF function uses two parameters, the data set range and the condition, in the following syntax:
=COUNTIF (data set range, condition)
For example, if you want to count cells that exactly match a number or value, just enter that number or value. To count cells that are greater than or less than a value, use the symbols >, >=, <, and 1.)
Mastering Accrued Interest Calculations with Microsoft Excel
Microsoft Excel is not just a spreadsheet program; it's a powerful tool for financial calculations, including the computation of accrued interest for various securities. Excel's built-in functions, ACCRINT and ACCRINTM, are specifically designed to simplify the process of calculating accrued interest for securities that pay periodic interest and those that pay at maturity, respectively. This article delves into the nuances of these functions, providing a detailed guide on how to use them effectively, along with common pitfalls to avoid.
Using the Bond Duration Add-in Functions
Making bond duration calculations? Microsoft Excel can help. Excel provides two functions that help you with bond duration calculations.
Using Excel's Xirr and Xnpv Add-in Functions
Making internal rate of return or net present value calculations with Microsoft Excel? Make sure you aren't unnecessarily limiting your options. In addition to the well-know IRR and NPV financial functions, Microsoft Excel also supplies two powerful add-in functions, XIRR and XNPV, that can expand your analytical possibilities.
