Pivot table - Count function with getpivotdata

[Marckas]

Hello all, I am trying to count actual hours greater than 0 in a pivot table. It seems simple enough but the way the pivot table is set as 1. project type 2. application name and then the data is actual hours which is also displayed by year and then month. I am trying to count how many applications in a project type has actuals greater than 0 in a given month. I used the countif function to count the number of apps having actual greater than 0 with a defined range. The problem is that this is a pivot table worksheet meaning it changes which means that the range stays the same and so it counts the wrong apps. I am trying to figur out if I could have a range change with a condition or use the getpivotdata function with a count function. Someone please help!!!

 

[SkipVought]

Hi,

Persorm ALL your statistical calculation using the SOURCE DATA table; not the PivotTable.

Skip,

_{Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference!}