Formula inquiry: Counting a specific name in multiple columns in one sheet
I am trying to create a formula within Sheet Summary to count the number of times each initiative was listed within a cell in four different columns. The columns are below. I used the following formula: =COUNTIF([Initiative]:[Initiative], [Initiative 2]:[Initiative 2], [Initiative 3]:[Initiative 3], [Initiative 4]:[Initiative 4], "New Patient Scheduling Lag") but it returned an "incorrect argument statement". Can you please help me with the correct formula? Thank you!
Help Article Resources
Check out the Formula Handbook template!