Listing and counting unique values that match criteria

Rodney2485 

You have a few options here. I'd go with GROUPBY because it will allow you to apply multiple functions to the data. You may have to change the arrangement, but it handles this task well.

=LET(
    row_field, Tasks[Wave '#],
    f, row_field = rpt_filter,
    values, HSTACK(Tasks[Task '#], Tasks[Task '#], Tasks[Task Status]),
    fn, HSTACK(COUNTA, ARRAYTOTEXT, ARRAYTOTEXT),
    agg, GROUPBY(row_field, values, fn, , 0, , f),
    DROP(agg, 1)
)