CountIf

[Michelle]

I have a spread sheet and I need to count the # of times something happens
per day. Example would be I have the following data.
Date Outcome
1.1.05 Y
1.2.05 Y
1.2.05 Y
1.2.05 N
1.2.05 N
1.3.05 N
1.3.05 Y

I want the results to be as follows
Date Positive Negative
1.1.05 1 0
1.2.05 2 2
1.3.05 1 1 etc.

[James M]

Michelle,

Have you tried using a pivot table?

J

"Michelle" wrote:

> I have a spread sheet and I need to count the # of times something happens
> per day. Example would be I have the following data.
> Date Outcome
> 1.1.05 Y
> 1.2.05 Y
> 1.2.05 Y
> 1.2.05 N
> 1.2.05 N
> 1.3.05 N
> 1.3.05 Y
>
> I want the results to be as follows
> Date Positive Negative
> 1.1.05 1 0
> 1.2.05 2 2
> 1.3.05 1 1 etc.

[Michelle]

No

"James M" wrote:

> Michelle,
>
> Have you tried using a pivot table?
>
> J
>
> "Michelle" wrote:
>
> > I have a spread sheet and I need to count the # of times something happens
> > per day. Example would be I have the following data.
> > Date Outcome
> > 1.1.05 Y
> > 1.2.05 Y
> > 1.2.05 Y
> > 1.2.05 N
> > 1.2.05 N
> > 1.3.05 N
> > 1.3.05 Y
> >
> > I want the results to be as follows
> > Date Positive Negative
> > 1.1.05 1 0
> > 1.2.05 2 2
> > 1.3.05 1 1 etc.

[Bob Phillips]

Then maybe you should.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Michelle" <[email protected]> wrote in message
news:[email protected]...
> No
>
> "James M" wrote:
>
> > Michelle,
> >
> > Have you tried using a pivot table?
> >
> > J
> >
> > "Michelle" wrote:
> >
> > > I have a spread sheet and I need to count the # of times something
happens
> > > per day. Example would be I have the following data.
> > > Date Outcome
> > > 1.1.05 Y
> > > 1.2.05 Y
> > > 1.2.05 Y
> > > 1.2.05 N
> > > 1.2.05 N
> > > 1.3.05 N
> > > 1.3.05 Y
> > >
> > > I want the results to be as follows
> > > Date Positive Negative
> > > 1.1.05 1 0
> > > 1.2.05 2 2
> > > 1.3.05 1 1 etc.

[Tom Ogilvy]

=sumproduct(--(A1:A30=DateValue("1/1/05")),--(B1:B30="Y"))

--
Regards,
Tom Ogilvy


"Michelle" <[email protected]> wrote in message
news:[email protected]...
> I have a spread sheet and I need to count the # of times something happens
> per day. Example would be I have the following data.
> Date Outcome
> 1.1.05 Y
> 1.2.05 Y
> 1.2.05 Y
> 1.2.05 N
> 1.2.05 N
> 1.3.05 N
> 1.3.05 Y
>
> I want the results to be as follows
> Date Positive Negative
> 1.1.05 1 0
> 1.2.05 2 2
> 1.3.05 1 1 etc.

[Michelle]

I tried this and it does not seem to return the # of times that Y hapens on
the given date.

"Tom Ogilvy" wrote:

> =sumproduct(--(A1:A30=DateValue("1/1/05")),--(B1:B30="Y"))
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Michelle" <[email protected]> wrote in message
> news:[email protected]...
> > I have a spread sheet and I need to count the # of times something happens
> > per day. Example would be I have the following data.
> > Date Outcome
> > 1.1.05 Y
> > 1.2.05 Y
> > 1.2.05 Y
> > 1.2.05 N
> > 1.2.05 N
> > 1.3.05 N
> > 1.3.05 Y
> >
> > I want the results to be as follows
> > Date Positive Negative
> > 1.1.05 1 0
> > 1.2.05 2 2
> > 1.3.05 1 1 etc.
>
>
>

[Tom Ogilvy]

If applied correctly, it will.

--
Regards,
Tom Ogilvy


"Michelle" <[email protected]> wrote in message
news:[email protected]...
> I tried this and it does not seem to return the # of times that Y hapens
on
> the given date.
>
> "Tom Ogilvy" wrote:
>
> > =sumproduct(--(A1:A30=DateValue("1/1/05")),--(B1:B30="Y"))
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> >
> > "Michelle" <[email protected]> wrote in message
> > news:[email protected]...
> > > I have a spread sheet and I need to count the # of times something
happens
> > > per day. Example would be I have the following data.
> > > Date Outcome
> > > 1.1.05 Y
> > > 1.2.05 Y
> > > 1.2.05 Y
> > > 1.2.05 N
> > > 1.2.05 N
> > > 1.3.05 N
> > > 1.3.05 Y
> > >
> > > I want the results to be as follows
> > > Date Positive Negative
> > > 1.1.05 1 0
> > > 1.2.05 2 2
> > > 1.3.05 1 1 etc.
> >
> >
> >

[Rock]

The formula of sumproduct worked well!

Try to look at your date fomat Michelle to have exact value in between quotation:

=sumproduct(--(A1:A30=DateValue("1/1/05")),--(B1:B30="Y"))

Regards
Rock

[Michelle]

Not to sound dumb but are the -- spaces?

"Rock" wrote:

>
> The formula of sumproduct worked well!
>
> Try to look at your date fomat Michelle to have exact value in between
> quotation:
>
> =sumproduct(--(A1:A30=DateValue("1/1/05")),--(B1:B30="Y"))
>
> Regards
> Rock
>
>
> --
> Rock
> ------------------------------------------------------------------------
> Rock's Profile: http://www.excelforum.com/member.php...o&userid=29723
> View this thread: http://www.excelforum.com/showthread...hreadid=494582
>
>