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

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

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

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