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

Hi Again Jim;
Well it is very simple. You have to change the set up of the field in the
pivot table. What you can do is:
1- call the fields table
2- Step up on heading Tag of the field that you need to chage
3- Double click on it. Then it will appear the field set up and it should be
a COUNT
4- Change it to Sum or anyother you need.

Best of luck.

Argy

"Jim" wrote:

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