COUNTIFS formula troubleshooting in Sheet Summary

KarenTF

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])

Peggy Parchert

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

Peggy Parchert

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

KarenTF

Thank you! That solved my issue :)