Excel COUNTIFS Function Tips

How to Use Counta Function

The COUNTA function is usually used for counting the non-empty cells in a given cell range.

COUNTIFS Function (multiple criteria)

The COUNTIFS() function is an extended version of the COUNTIF() function which is used to conditionally count items/ cells based on certain criteria.