Wildcard Posted July 28, 2011 Share Posted July 28, 2011 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 More sharing options...
0 splur Posted July 28, 2011 Share Posted July 28, 2011 You've got to unhide the hidden zeroes and delete the zeroes from your spreadsheet. Link to comment Share on other sites More sharing options...
0 Wildcard Posted July 28, 2011 Author Share Posted July 28, 2011 hmm anyway i can have excel ignore it if the value was zero and not blank ? Link to comment Share on other sites More sharing options...
0 splur Posted July 28, 2011 Share Posted July 28, 2011 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 More sharing options...
Question
Wildcard
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