How to Count the Number of times a Value Appears in a Column in Another Sheet
I want to collect some data to populate a dashboard with. Essentially, I am trying to get a count of how many times a certain type of event occurred this year. I am trying to use the countif formula to pull data from a column (column name: "Event Type") in another sheet (sheet name: "On-Site Event Request") and, for example, count the number of times that the word "Networking" is in that column. What should this formula look like?