Countif for Pivot
 

Hi there.
I know I cannot use countif in pivot table, but that is the information I
really need. Is there any way around it?

Basically I need to count the number of cells in a field where the value is
0. And also I must be able to group the outcome by month - which is why it
would be ideal to do this in conjunction with the pivot table.

Any suggestion?

Countif for Pivot
 

Krissy,

Use another column in your data table with the formula

=/Cell with value/ 0

Like

=B20

then use that field to show (and thus count) only TRUE results in your pivot table.

HTH,
Bernie
MS Excel MVP


"Krissy" wrote in message
...
Hi there.
I know I cannot use countif in pivot table, but that is the information I
really need. Is there any way around it?

Basically I need to count the number of cells in a field where the value is
0. And also I must be able to group the outcome by month - which is why it
would be ideal to do this in conjunction with the pivot table.

Any suggestion?

Countif for Pivot
 

Thanks Bernie

I try it!

"Bernie Deitrick" wrote:

Krissy,

Use another column in your data table with the formula

=/Cell with value/ 0

Like

=B20

then use that field to show (and thus count) only TRUE results in your pivot table.

HTH,
Bernie
MS Excel MVP


"Krissy" wrote in message
...
Hi there.
I know I cannot use countif in pivot table, but that is the information I
really need. Is there any way around it?

Basically I need to count the number of cells in a field where the value is
0. And also I must be able to group the outcome by month - which is why it
would be ideal to do this in conjunction with the pivot table.

Any suggestion?