Countif for Pivot

[Krissy]

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?

 

[Bernie Deitrick]

Krissy,

Use another column in your data table with the formula

=/Cell with value/ > 0

Like

=B2>0

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

HTH,
Bernie
MS Excel MVP

 

[Krissy]

Thanks Bernie

I try it!

Krissy,

Use another column in your data table with the formula

=/Cell with value/ > 0

Like

=B2>0

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

HTH,
Bernie
MS Excel MVP