A
austral16
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hi,
I am trying to use the averageif function to average a column of values with the condition that zero values are ignored in the average.
In a normal spreadsheet this works fine with = averageif(T2:T6265, ">0"
.
However, in a pivot table, this same argument = averageif(landown, ">0" contains an error.
Can the averageif function be used in pivot tables and if not, do you have any other suggestions.
I can do it by replacing all zero values in the column to missing values before creating the pivot table, however I would prefer another solution
Cheers
Michael
I am trying to use the averageif function to average a column of values with the condition that zero values are ignored in the average.
In a normal spreadsheet this works fine with = averageif(T2:T6265, ">0"
. However, in a pivot table, this same argument = averageif(landown, ">0"
contains an error. Can the averageif function be used in pivot tables and if not, do you have any other suggestions.
I can do it by replacing all zero values in the column to missing values before creating the pivot table, however I would prefer another solution
Cheers
Michael