# Dashboard formulas - Need to count if a person is included in Owner Column and the task is not close

Options

JFrye
✭

Trying to calculate the number of tasks by person that are not closed. I currently have:

=COUNTIFS({Tracker Range 6}, ="Andy", {Tracker Range 2}, <>"CLOSED")

Where the Range 6 is the Owner column and Range 2 is the Status Column (Open, Closed, Hold).

I am getting responses, but I think it is only counting where the owner is the only entry in the cell...many have shared ownership. How do I indicate where the name is included and not the only entry?

## Comments

## Help Article Resources

#### Categories

- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 61.3K Get Help
- 321 Global Discussions
- 197 Industry Talk
- 418 Announcements
- 4.2K Ideas & Feature Requests
- 126 Brandfolder
- 153 Just for fun
- 124 Community Job Board
- 441 Show & Tell
- 26 Member Spotlight
- 1 SmartStories
- 278 Events
- 34 Webinars
- 7.3K Forum Archives

Want to practice working with formulas directly in Smartsheet?

Check out the

Check out the

**Formula Handbook template!**