I'm currently using the following in a column of cells:
=IF(SUM(I3:L3)=0,"",SUM(I3:L3))

However when using a pivot table on this workbook I am getting a count
although
the sum is 0. How do I get the pivot table to not count 0?

Thanks