I can't seem to find anything with regards to this.. sorry

R

Rameris

I have to keep track of people attending meetings.

The person prior to me created a spreadsheet with all the people attending
with an alpha character in each meeting they attended (an X) and nothing if
they didn't attend.

I now have to total all the meetings the people attended and do a printout
of the totals.

It would have been easy if they had used a 1 for attended and a 0 for not
attending but this spreadsheet goes back a number of years so I have to add
them manually.

While I can add mentally the volume is crazy and I was wondering if there is
a way to have it calculate the number of "X's" in a particular range.
 
A

Amish

There are several options, here are two simple ones:
=COUNTA(B2:B5000) will count all cells with something in them
or
=COUNTIF(B2:B5000,"X") will count all cells with an X in them
 
S

Stefi

If "X's" are in a separate column, say column A then

=COUNTIF(A:A,"X")


--
Regards!
Stefi



„Rameris†ezt írta:
 
R

ryguy7272

Please provide a few samples of your data. For instance, are the "X's" in
the same cell with the people's names (I doubt it) or are they in cells
adjacent to the people's names (most likely scenario).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top