From the course: Excel Weekly Challenge

Unlock this course with a free trial

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

Tally the number of guests for a party

Tally the number of guests for a party - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Tally the number of guests for a party

“

- [Instructor] Are you ready to think? That's what this challenge is going to force you to do, because your result might not look like mine. The idea is we're having an event, and we need a tally of who's coming, and we need to be able to change it, update it, add people, remove people, whatever, and look at the responses: "I'll be there", there's a Y, there's a yes with four s's, "If I'm in town, I'll be there." So, in order to make this useful, we've got to make some decisions. We might have to add some columns, do some things and steps, whatever it takes. You've got an invited column and everybody who's saying yes, and then you've got to add their guests. So, work this out, make this useful and get a number in H1. After that, add some more people, change the number of guests, and make sure everything updates. Pause the video, work that out, and come on back. Okay, you're back. First of all, I'm going to put…

Contents