What version of Excel are you using?
What is in the cells - text, numbers, dates?
What is the formula you are using?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"bec" wrote:

I'm trying to add a formula in a pivot table, yet do not want to count "0".
Please help.
bec