Home » Posts

Course completion summary with criteria

This example illustrates one way to summarize course completion data using a criteria, in this case "group". In the example shown, the formula in I4 is: =COUNTIFS($B$4:$B$11,$H4,D$4:D$11,"")/COUNTIFS($B$4:$B$11,$H4)

April 14, 2025 · 1 min · 50 words · Jennifer Pitts

Table of Contents

Explanation

Note: there are many ways to summarize data with COUNTIFS, SUMIFS, etc.

This example shows one specific and arbitrary way.

The summary table in H3:K5 summarizes course completion by group instead of user.

Excel formula: Course completion status summary

In this example, group represents the additional criteria.

COUNTIF can be used to count cells that…

Excel formula: Summary count with COUNTIF

Excel formula: Summary count by month with COUNTIFS

Excel formula: Summary count with percentage breakdown

Excel formula: Two-way summary count

Excel COUNTIFS function

Explanation#

Explanation