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.
Geeky Gadgets

How to solve Excel COUNT problems with COUNTIFS Function

The COUNTIFS function in Excel is a powerful and versatile tool for counting cells based on multiple criteria. It offers a significant advantage over the COUNTIF function, which is limited to handling ...