From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 24,600 courses taught by industry experts.

Get a count of possible venues

Get a count of possible venues - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Get a count of possible venues

“

- [Instructor] You and I are plannin' a retirement party for a dear friend and we want it to be good. So we've compiled this list of venues, and we would like to know where we're at. This is where you can help. Write formulas to get a count of how many possible venues we have, then a count of how many yeses for venues that we are still considering, and then a no for the venues that we are no longer considering. And it's important that you write your formulas in such a way that they will account for any new venues that we add to this list. So go ahead, pause the video, then come back and I'll walk you through one solution. Okay, here is one solution. I am gonna click inside this data set, and go up to format as table. I'll just pick a color, let's go with the black, my table does have headers, and it has pre-selected the entire data set, OK. Next I'm gonna go into the count of venues, equals, and I'm gonna use the…

Contents