Forum Discussion

Copper Contributor

Jun 17, 2021

Solved

Count number of occurrences

Original Table of Results Name Group Status Joe marketing, all users Passed Mary digital1, all users In Progress John digital2, all users Not Started Bob marketing, all users...

excel

Formulas and Functions

HansVogelaar
Jun 17, 2021
Gerry_Morley

You can use COUNTIFS with a wildcard for the group:

See the attached sample workbook.
Countifs.xlsx11 KB

HansVogelaar

MVP

Jun 17, 2021

Gerry_Morley

You can use COUNTIFS with a wildcard for the group:

See the attached sample workbook.

Countifs.xlsx11 KB

Gerry_Morley

Copper Contributor

Jun 17, 2021

Thank you very much. This is super helpful. Really appreciate it.