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
-
Are you able to provide some screenshots for context?
Answers
-
Are you able to provide some screenshots for context?
-
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.
-
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")
-
let me try it.... thank you.
I know I can do it by converting the data into a separate pivot file as well.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!