Formula Assist
Hello having some issues with formulas, can you help spot the error?
=COUNTIF([(OBC) Assigned OBC Coordinator]:[(OBC) Assigned OBC Coordinator], "Corrisa Evans", [(OBC) If yes, choose primary error type]:[(OBC) If yes, choose primary error type])
Best Answer
-
Hey @Gigi_Ris
You cannot use SUMIFS as you have it written. SUMIFS only works when the range you are summing is numeric. Since you are counting checkmarks where the value of each is one, the count and the sum will be identical. The syntax you used above is that of COUNTIFS, not SUMIFS where an additional range is expected.
COUNTIFS([(OBC) Assigned OBC Coordinator]:[(OBC) Assigned OBC Coordinator], "Gladys Risling", [(OBC) Errors or escalation - check if yes]:[(OBC) Errors or escalation - check if yes], =1)
If you have many names to count and you are using this formula in a column, you can add [(OBC) Assigned OBC Coordinator]@row in place of "Gladys Risling" and dynamically count the people in your column. A simple report will also count the people and could also be used in a dashboard.
Kelly
Answers
-
Hey @Gigi_Ris
There is an extra range in the formula - A countif (or countifs) only needs the range-criteria pair
=COUNTIF([(OBC) Assigned OBC Coordinator]:[(OBC) Assigned OBC Coordinator], "Corrisa Evans")
If you intended to include another criteria with the other range, to bring your total of criteria to more than just the one, you will need to swap to COUNTIFS to do so
Kelly
-
@Kelly Moore - yes i have two things to count, tried this little number below. I am counting a check mark and want it to only count the check marks for a specific person.
=SUMIFS([(OBC) Assigned OBC Coordinator]:[(OBC) Assigned OBC Coordinator], "Gladys Risling", [(OBC) Errors or escalation - check if yes]:[(OBC) Errors or escalation - check if yes], =1)
-
Hey @Gigi_Ris
You cannot use SUMIFS as you have it written. SUMIFS only works when the range you are summing is numeric. Since you are counting checkmarks where the value of each is one, the count and the sum will be identical. The syntax you used above is that of COUNTIFS, not SUMIFS where an additional range is expected.
COUNTIFS([(OBC) Assigned OBC Coordinator]:[(OBC) Assigned OBC Coordinator], "Gladys Risling", [(OBC) Errors or escalation - check if yes]:[(OBC) Errors or escalation - check if yes], =1)
If you have many names to count and you are using this formula in a column, you can add [(OBC) Assigned OBC Coordinator]@row in place of "Gladys Risling" and dynamically count the people in your column. A simple report will also count the people and could also be used in a dashboard.
Kelly
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!