Pivot tables: SUM not COUNT!!!!!!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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"
 
Back
Top