Hi Martin

You cannot "fix" Excel's method used with Data.
The default for Numeric data is SUM, and the default for text data is
COUNT.
I suspect that your range of numeric data, also includes blank cells,
which would cause Excel to switch from using Sum to Count.

If there are not blank cells within your data range, but there are blank
cells below the used range, then try using a dynamic range for your
data, to limit the range to that containing numeric data.
Otherwise, I'm afraid you will have to change the selection each time,
as you do at present.

--
Regards

Roger Govier


"Martin James Thornhill"
wrote in message
...

Whenever I create a pivot table, Excel has a nasty habit of always
(wrongly)
assuming function COUNT to apply to any data placed in the pivot
table, even
if the data is purely numeric.

How do I permanently fix Excel's cretinous obsession with counting and
replace it with the required function?