How-To Geek on MSN

How to do math in Excel without formulas

The fix for the disposable formula habit in Excel is already on your screen. At the very bottom of your Excel window is a ...
How-To Geek on MSN

Don't trust Excel's COUNTA function to count non-blank cells—here's a better method

In most counting scenarios in Excel, COUNTBLANK reliably counts blank cells, and COUNTA reliably counts populated cells. However, with these functions comes a problematic paradox: an empty string from ...