The simplest way is to add the V's in exactly the same cell on all the WSs,
say A25.

Then, add those cells on the master:

=Sum(Sheet1:Sheet4!A25)

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Kelly" wrote in message
...
I have a spreadsheet to track attendance. On my summary sheet I need to
total
all the cells that contain V (For Vacation), A (For Absent), S (For Sick).
The spreadsheet has 4 worksheets. Each sheet is one quarter. How can I have
Excel add all the V's for example and place the total number in a cell on my
summary page?

Thanks
Kelly