• 0

Excel Pivot Table Question


Question

Excel is counting blank cells as 0 values when calculating averages for pivot table values. How do I get it to ignore and omit blank cells from the calculations? Currently using Excel 2010

Any help would be appreciated

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0

Yeah, sorry I'm not sure. The pivot table is kind of automated, you could probably easily do that with a custom IF statement but I don't think you can do custom formulas in a pivot table.

Link to comment
Share on other sites

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.