Browse » Home
Sunday, July 24, 2011
How to Display a Count of Cells on the Bottom of the Window in Excel
1. Open Microsoft Excel and load the spreadsheet you want to edit. This can be an existing file, or you can just use the default new page to test the functions.
2. Enter data in the first column. Use the following data to populate the 'A' column on the spreadsheet:Price
2.00
3.00
4.00
3. Use the Count or CountA function in the bottom field. The following code is an example of how to use the Count function:=count(a1:a4)To use the CountA function, enter the following code instead:=countA(a1:a4)The equal sign is used to denote a formula. This is prefixed in all cells that contain formulas. The two alphanumeric numbers in the parenthesis are the range of fields. The 'a' represents the column and the number represents the row.
4. Use the CountBlank function to count the number of blank cells. This tells you how many cells contain no data in your list of fields. To use the CountBlank function in conjunction with the test data, type the formula below into a cell at the bottom of the spreadsheet:=countblank(a1:a5)
5. Use the CountIF function to display a count only if a particular cell contains the specified data. For instance, suppose you want to count how many cells contain '2.' Use the CountIF function to determine the output. The code is below:=countif(a1:a4, 2.00)The first parameters are the range of cells to check. The second parameter (2.00) is the value to count.
6. View the results. The Count function returns the value of '3.' This is because only three out of the four cells populated have numerical values. The CountA function returns '4.' CountA displays a count of all cells regardless of the data type. For the CountBlank function, the range has only one blank cell, so the return value is '1.' Finally, for the CountIF function, there is one cell with the matching value, so the return value is '1.'