PivotTable Question

[Guest]

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)

 

[Guest]

Try COUNTIF(range,criteria)

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

=if(c2<0,1,0)

 

[Dave Peterson]

In the pivottable????

Try COUNTIF(range,criteria)