COUNTIFS formula troubleshooting in Sheet Summary
I have form that has Site Location and two separate checkbox options, where either both requirements will be checked for New Hire or only the latter for Existing Employee. I'd like to create a Sheet Summary formula to COUNTIFS a certain Site Location is selected and if the New Hire checkbox is selected, I want to get a count of each per site, but my formula isn't working and I'm not sure what the error is. Here is my current formula, but I'm not having any luck. Ideas?
=COUNTIFS(Site Location:Site Location, Site 1, [New Hire:New Hire, 1])
Best Answer
-
Hello @KarenTF
Hope you are doing well. Try adjusting your formula - adding brackets and quotes around "Site 1".
=COUNTIFS([Site Location]:[Site Location], "Site 1", [New Hire]:[New Hire], 1])
Thanks, Peggy
Answers
-
Hello @KarenTF
Hope you are doing well. Try adjusting your formula - adding brackets and quotes around "Site 1".
=COUNTIFS([Site Location]:[Site Location], "Site 1", [New Hire]:[New Hire], 1])
Thanks, Peggy
-
Thank you! That solved my issue :)
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!