Sorry you cannot. If there are blank cells or cells with text the default
will be COUNT; or other wise it will be SUM..

If this post helps click Yes
---------------
Jacob Skaria


"YY san." wrote:

Hi,
By default, the summarise value field in the pivot tabel is always COUNT.
Does anyone know that this default, can it be change to SUM?
Thank you in advance