May 30th, 2010, 02:03 PM
posted to microsoft.public.excel.worksheet.functions
|
|
Count number of people
This is easy and it works. Now I need to understand why! Thanks!!
"Bernard Liengme" wrote:
=ISTEXT(A1)+ISNUMBER(FIND("&",A1))
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
REMINDER: These newsgroups are about to die. We will all meet again at
http://social.answers.microsoft.com/...ry/officeexcel
"burtlake" wrote in message
news
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?
|