Monday, April 3, 2017

Counting in Excel

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.

=COUNT(value1,...)
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).

=COUNTA(value1,...)
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).

=COUNTBLANK(range)
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.

Wednesday, March 1, 2017

Move Text in Word with F2

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?

  1. Select the text to move.
  2. Press the F2 function key on your keyboard.
  3. Place the cursor (insertion point) where you want to move the text to and then press ENTER.

Monday, February 20, 2017

Hiatus is over

My apologies for letting this blog become neglected for the past couple of years. I've have a lot of tough personal issues with myself and family. I finally feel like I'm in a place to resume posts. The next new post will be in March 2017.