There are three simple COUNT functions if you need to count cells in Microsoft Excel. There are two additional COUNT functions (COUNTIF and COUNTIFS) that are a little more complex and require multiple arguments. For this post, I'll only focus on COUNT, COUNTA, and COUNTBLANK.
This function counts the number of cells in a range that contain numbers. If the cell contains any alpha character, it will not be counted. The arguments can be a single cell, range of cells, or a non-contiguous range of cells (multiple arguments).
This function counts the number of cells in a range that are not empty. Think of the A as ALL. I want a count of ALL cells that contain something. The "something" can be any character, as long as the cell is not empty. The arguments can be a single cell, range of cells, or a non-contiguous range of cells (multiple arguments).
This function counts the number of empty cells in a specified range of cells. If someone used the SPACEBAR to "clear" a cell, this function will recognize the space as a character and count it. It truly means the cell has nothing entered in it.
Monday, April 3, 2017
Wednesday, March 1, 2017
Shortcuts are wonderful. I've used CTRL+X and CTRL+V for a simple cut and paste, but have you used the function key F2?
- Select the text to move.
- Press the F2 function key on your keyboard.
- Place the cursor (insertion point) where you want to move the text to and then press ENTER.