COUNTIF WITH MULTIPLE CHECKBOXES
I have a column called Systems. This allows users to thick multiple checkboxes example "Lighting","CCTV","Intruder"....
I would like to issue reports using the COUNTIF formula if the value of Systems has for example "Lighting" ticked in the checkbox. When using COUNTIF it will only count the row if "Lighting" is the only system checked. If multiple systems are checked apart from Lighting" COUNTIF will not add the row.
I think I have to use a combination of COUNTIF and CONTAINS but I am not managing to make it work.
This is the syntax that I am using:
Help Article Resources
Check out the Formula Handbook template!