I have a large amount of data with many columns that have cells with 0 values. I have no issue writing this for the data. However, I need to be able to do this type of average in a pivot table. I know you can't do it in Excel 2007, can you in Excel 2010.