How-To Geek on MSN

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

Counting non-empty cellsThe COUNTBLANK-COUNTA conflict (and how to fix it)Summary: Choosing the right counting functionIn most counting scenarios in Excel, COUNTBLANK reliably counts blank cells, and ...
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 ...