Sum to display both Zeroes and Blanks

[austin1]

I'm having an issue with calculated fields in a pivot table formula. I've tried everything and reverted back to my original simple formula in the attached pictures. 1Q 2014 calculated field =SUM('Q1 2014','Feb 2014','Mar 2014' ).

Any sum greater than zero works fine however I'm having issues with "zeroes". If the sum is truly zero (i.e. the data source cells = 0) I want the standard display of "0" however if the sum is blank (i.e. the data source cells are empty or N/A) I want it to display a "blank", not a zero. I need to be able to see both blanks and zeroes on my pivot table.

Thanks,
Austin

 

[Jonmo1]

Try

=IF(COUNT('Q1 2014','Feb 2014','Mar 2014'),SUM('Q1 2014','Feb 2014','Mar 2014'),"")

 

[austin1]

Jonmo1,

Excel still displays "0's".

If the columns are: Q1, Q2, Q3, Q4
Person A should be: "blank", 1,1,0
Person A still showing 0,1,1,0

 

[austin1]

Please see my post at the link below to see the Excel file / issue that I'm still having.

Formula needs to show both blanks and zeroes.

Thanks.