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


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.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!