I have a spreadsheet with multiple worksheets. Each worksheet holds the data for an individual person. Some of the data is populated from text based drop down lists. I want to create an overview page which counts up each answer and returns a total for how many there are. For example, I want to find out how many times the same cell on each worksheet contains the drop down answer "Yes" returning 14 out of the 60.
Apartment Conversion for Increased Rental Income Category: AutoCAD, Building Architecture, Building Regulations, Construction, Construction Management, Home Design, Interior Design, Project Management Budget: $750 - $1500 USD
4K Creative Promo Video Edit Category: After Effects, Animation, Color Grading, DaVinci Resolve, Final Cut Pro, Video Editing, Video Services Budget: $30 - $250 USD
