Excel Formula to count if ANY text or number is in a cell

Closed
dathomas - Mar 17, 2015 at 05:38 PM
Hello,

I have a row of 8 cells and I want to count the number of cells that are populated on the row. If a cell is populated, I want to add 1 to count the total number of populated cells in another cell. For example, if 5 cells in the row are populated, I want the number 5 to show up in another cell. Any advice?