Creating a running total - using "x" to populate field

  • Thread starter Thread starter Bobbiec
  • Start date Start date
B

Bobbiec

I am looking how to do the following:

I've created a worksheet showing attendees at a meeting
which has many different sessions. I need to know how
many will be in each individual session. I am using the
letter "x" as the indicator that they will be at a
particular session. How do I keep a running total of how
many are attending each session at the bottom of each
column? I will be adding and deleting attendees over the
next couple of weeks. Thanks in advance..!
 
Bobbie, use something like this =COUNTIF(A1:A16,"x") or even this
="The Number Attending Is " & COUNTIF(A1:A16,"x")

--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
Bobbie,

Assuming you have a table with Attendees in Col A and a column for each
session, then

=COUNTIF("column range","X")

will return the number of cells marked as you have indicated.

PC
 
You can use a countif statement.
For example Countif(b5.b15,"x")
This will give you a total of cell that contain a letter x.
Don't forget to put the quotation mark around the letter x.
 
Back
Top