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 Vs for example and place the total number in a cell on my
summary page?

Thanks
Kelly

=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

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

Thank you so much!! This is just what I needed to finish my spreadsheet!!

"Bob Phillips" wrote:

=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