Home » Posts

Count non-blank cells by category

To count non-blank cells by category, you can use the COUNTIFS function. In the example shown, the formula in G5 is: =COUNTIFS(data[Group],F5,data[Done],"") where data is an Excel Table in the range B5:D16. As the formula is copied down, it returns a count of non-blank dates by Group as seen in the worksheet.

April 14, 2025 · 1 min · 75 words · Brittany Mendoza

Table of Contents

Explanation

In this example, the goal is to count non-blank dates in column D by group.

All data is anExcel Tablenameddatain the range B5:D16.

This problem can be solved with theCOUNTIFS function, as explained below.

Excel formula: Summary count with COUNTIF

COUNTIFS function

The Excel COUNTIFS function returns the count of cells that meet one or more criteria.

COUNTIFS accepts ranges and criteria in pairs.

Because there are 5 rows in the table where the group is “A”, COUNTIFS returns 5.

Excel formula: Summary count by month with COUNTIFS

Excel formula: Summary count with percentage breakdown

Excel COUNTIFS function

Explanation#

COUNTIFS function#

Explanation

COUNTIFS function