[mkral]

Sorry for the basic posts. I am sure that I am just missing something here, but I am just not "getting" excel.

I am creating an attendance sheet. It has everyone's name on it & then different column for each week. If someone is there, I put an x in that weeks column for them, if not, I leave it blank. I would like to add a field at the bottom of the sheet that would automaticaly tally up the number of x's on any given week, so that I can keep a running total of how many we had in attendance on any given week.

Thanks again for any help you can offer.

[philm]

You need to use the COUNTIF function. In the cell you want to have the total of attendees, put:

=COUNTIF(B1:B100,"x")

where B1:B100 is the range of cells you are looking at.

[mkral]

Thank you! That is exactly what I was looking for