PivotTable Question

[carl]

I have a large database that looks like this:

Date Time New Price
20060314 95511 -0.4
20060314 95513 1
20060314 95518 -0.2
20060314 95531 2.25
20060314 95533 0.75
20060314 95536 0.55

Can the Pivot Table Function count the instance where New Price is less than
zero for a given day ?

Thank you in advance

[Dave Peterson]

I'd just add another column to the raw data to look at that value:

=if(c2<0,1,0)



carl wrote:
>
> I have a large database that looks like this:
>
> Date Time New Price
> 20060314 95511 -0.4
> 20060314 95513 1
> 20060314 95518 -0.2
> 20060314 95531 2.25
> 20060314 95533 0.75
> 20060314 95536 0.55
>
> Can the Pivot Table Function count the instance where New Price is less than
> zero for a given day ?
>
> Thank you in advance

--

Dave Peterson

[lk]

Try COUNTIF(range,criteria)

"Dave Peterson" wrote:

> I'd just add another column to the raw data to look at that value:
>
> =if(c2<0,1,0)
>
>
>
> carl wrote:
> >
> > I have a large database that looks like this:
> >
> > Date Time New Price
> > 20060314 95511 -0.4
> > 20060314 95513 1
> > 20060314 95518 -0.2
> > 20060314 95531 2.25
> > 20060314 95533 0.75
> > 20060314 95536 0.55
> >
> > Can the Pivot Table Function count the instance where New Price is less than
> > zero for a given day ?
> >
> > Thank you in advance
>
> --
>
> Dave Peterson
>

[Dave Peterson]

In the pivottable????

lk wrote:
>
> Try COUNTIF(range,criteria)
>
> "Dave Peterson" wrote:
>
> > I'd just add another column to the raw data to look at that value:
> >
> > =if(c2<0,1,0)
> >
> >
> >
> > carl wrote:
> > >
> > > I have a large database that looks like this:
> > >
> > > Date Time New Price
> > > 20060314 95511 -0.4
> > > 20060314 95513 1
> > > 20060314 95518 -0.2
> > > 20060314 95531 2.25
> > > 20060314 95533 0.75
> > > 20060314 95536 0.55
> > >
> > > Can the Pivot Table Function count the instance where New Price is less than
> > > zero for a given day ?
> > >
> > > Thank you in advance
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson