Countif for Pivot

  • Thread starter Thread starter Krissy
  • Start date Start date
K

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
Click to expand...
would be ideal to do this in conjunction with the pivot table.

Any suggestion?
 
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
 
Thanks Bernie

I try it!

Bernie Deitrick said:
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
Click to expand...
 
Back
Top