How can I create a formula to count occurrences with THREE different value criteria.
I am trying to create a formula that will pull a count of occurrences with 3 specific values. I currently have a main sheet that is capturing a Child Care Center's student spaces by age and if the space is "Filled or Vacant." Screen capture of master sheet to source data for metrics sheet:
I then created a metrics sheet to track the cumulative data to later create a dashboard. The sheet is below:
What formula can I create to factor in the Center Name, Age Group, and Classroom Space for the metrics sheet?
Thank you for your help
Help Article Resources
Check out the Formula Handbook template!