=COUNTIF(A:A,"V")

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"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