PivotTable Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

carl - 31 May 2006 18:08 GMT

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

Reply to this Message

Dave Peterson - 31 May 2006 18:13 GMT

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

=if(c2<0,1,0)

> I have a large database that looks like this:
>
[quoted text clipped - 10 lines]
>
> Thank you in advance

Signature

Dave Peterson

Reply to this Message

lk - 31 May 2006 21:42 GMT

Try COUNTIF(range,criteria)

> I'd just add another column to the raw data to look at that value:
>
[quoted text clipped - 14 lines]
> >
> > Thank you in advance

Reply to this Message

Dave Peterson - 01 Jun 2006 00:25 GMT

In the pivottable????

> Try COUNTIF(range,criteria)
>
[quoted text clipped - 20 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message