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

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
- 10.7K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives

Want to practice working with formulas directly in Smartsheet?

Check out the

Check out the

**Formula Handbook template!**