=SUMPRODUCT(--(A3:A10="Jack"),--(OFFSET(A3:A10,,1)="P"))

Change the name to suit, the A/P to suit, and the ,,1 to reflect the day

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ajit Munj" wrote in message
...
I have created data as below:
A B C D E F
Sun Mon Tue Wed Thu Fri Sat....
1 2 3 4 5 6 7 .....31
Jack P P A P A P A P

I want to calculate how many Sundays, Tuesdays etc. Jack
was present and absent? How can I do this? (P=Present
A=absent)
Ajit
--
Knowldege is Power