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 ...
Hosted on MSN

8 tips to optimize and speed up Excel formulas

While Excel is a powerhouse for data analysis and manipulation, complex workbooks with tons of formulas can slow down your workflow in no time. After all, nobody wants to wait around for their ...