count non-blanks in 3 columns based on a specific name in another column

RLW

Column A has a mix of 18 individuals in it.

Column B-D have lists of actions they have/have not completed.

I want to count the non-blank (meaning they did an activity) in column B-D only for rows that match a specific name from column A.

Paul Newcome

Are you able to provide some screenshots for context?

Paul Newcome

Are you able to provide some screenshots for context?

RLW

private info so I can't show, but here is what I'm trying to do with Dummy data. The real data is in Smartsheet.

ss example 11-3.xlsx

Paul Newcome

You would need to insert a helper column (text/number) with the following column formula:

=COUNTIFS([Task A]@row:[Task C]@row, @cell = "")

Then you would use a SUMIFS to get your total for each person.

=SUMIFS([Helper Column]:[Helper Column], Name:Name, @cell = "Sample 1")

RLW

let me try it.... thank you.

I know I can do it by converting the data into a separate pivot file as well.