count conditional days - ajit

Bob,

Think I'm missing something here - what's the "A/P"?

Pete Rooney



"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" <ajitmunj@microsoft.com> wrote in message
> news:B656A0B2-8083-45FF-89A3-EB41B21BD54F@microsoft.com...
> > 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
>
>
>

Bob,
Ever wished the earth could open up and swallow you? "Absent/Presnt" - Doh!
Sorry to hijack this string with abject stupidity.

Pete



"Peter Rooney" wrote:

> Bob,
>
> Think I'm missing something here - what's the "A/P"?
>
> Pete Rooney
>
>
>
> "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" <ajitmunj@microsoft.com> wrote in message
> > news:B656A0B2-8083-45FF-89A3-EB41B21BD54F@microsoft.com...
> > > 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
> >
> >
> >