Thanks Bob,want some explanations
1. what is the use of "--" in formula?
2. What is offset function? Help on this functions is not available
with my excel version.
3. This query is not related with the given formula. How can I
use "and", "or" expression as it is used in dbase or foxpro (e.g.
if
(this conditions is true) .and.
(that conditions is true)
then
(do this)
..or.(do this)

"Bob Phillips" wrote:

=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