This should get you started. To count the total # of P's
for John for January (assuming your data below is just
for January), try:

=SUMPRODUCT((3:3="P")*(1:1="Sun"))

where John is listed on row 3 and the Days are listed in
row 1.

HTH
Jason
Atlanta, GA

-----Original Message-----
I use Excel 2000
I have sheet muster for my clients of January, 2005
like :
( P = Present, A=Absent )
A.....B.....C.....D.....
Days Sun Mon Tue Wed
Date 1 2 3 4

1 John P A A P
2 Lucy A P P A
3
Now I want to calculate the total Sundays, Mondays,
Tuesdays etc. present in
that month. How can I do this?
--
Knowldege is Power
.