I have a spreadsheet that is an master enrollment form for an event. As I add attendees I would basically like to index numbers in a column called "Headcount" which is Column G. Since the names are listed in Col. A under each attendee's local organization I can't just count the number of entries in Column A. However, I do have Column D, which is their email address, and that can be used for counting. So the formula in Column G would look something like this:



"If column D has an entry in it count this line as 1"

Then that formula would add 1 to the number in the line above it and display the result.

I hope this request is understandable and the function is possible. Please ask any question that will help with the understanding. I think this request is fairly simple for someone who is an advanced Excel user. It's just above my head. I tried find it in the Formulas section and didn't see anything that look appropriate.

Thanks for any help that can be provided.

In E2: =IF(D2="","",COUNTA($D$22)) (I don't know how to avoid this ugly green thing, but text inside parenthesis should read from $D$2 to D2)

Copy down.

To avoid the smiley, I use lowercase ":d2"

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you Pecoflyer!

Con piacere dottore

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Why the indexed headcount? Wouldn't just a single headcount suffice?

It worked like a charm! Thanks so much!