If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Count number of people
We will be hosting a large fund raiser. I need to know the number of people
attending. Here's my problem................ Some people come as couples, and some as singles. For example, I have listed Jim & Susan Brown. But in the same list I have Bill Smith, and Ann Johnson. If ALL of these people RSVP with a yes, it represents 4 attendees. I think the key to determining if it is 1 or 2 people attending is the ampersand "&". If I have an ampersand, it should count as two; no ampersand, it is 1. How can I use a function or functions to make this distinction, anc correctly enter the number of attendees in the spredsheet? |
Thread Tools | |
Display Modes | |
|
|