Adding Text Entries in a Cells
 

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

Adding Text Entries in a Cells
 

=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

Adding Text Entries in a Cells
 

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

Adding Text Entries in a Cells
 

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