Dear Jason,
I tried your formula but some problem is there. I have made two sheets namely
Muster & Bill. In Muster, instead of P & A, I have entered the name of
newspaper. Hence I made some change in formula like
:=SUMPRODUCT((Muster!3:3<"")*(Muster!1:1="Sun")), it does not get tallied
with the total number of days in that month. e.g. In month January, 2005
there are 4 instances of Sun-Wed & 5 instances of Sat and Fri i.e. total 31
days.(I have not kept any cell blank as I have put a newspaper from 1 to 31).
After entering formula, it shows total 29 days, i.e. 5 instances of Sat. & 4
instances of Sun-Fri. Where am I going wrong?. Secondly, by refering 4:4 and
2:2, if accidently somebody enter a day and date, suppose in a far away cell
IN2 and IN4, the formula will show additional day. Pl. guide.
ajit

"Jason Morin" wrote:

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
.