Ask Your Question

Pivot table not seeing data as numeric, hence SUM does not work...why ?

asked 2017-01-29 01:53:46 +0200

mostlydice gravatar image

I have a created a pivot table to sum data on three columns. They are numeric , but the Pivot table will not see them as numbers, hence will not sum them.

The reason I know this is if I do COUNT, it will count the rows. if I do Count (Numbers Only), it will not count.

How do I get the Pivot table to see the data that IS numeric , as numeric.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-01-29 02:33:25 +0200

robleyd gravatar image

updated 2017-01-29 02:38:53 +0200

Just because they look like numbers does not mean they are stored as numbers. Press F8 or toggle View | Value Highlighting and look at the colour of the cell entries; text cells are formatted in black, formulae in green, and number cells in blue.

Look at Menu=> Data | Text to Columns for converting numbers formatted as text to numbers.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-01-29 01:53:46 +0200

Seen: 1,507 times

Last updated: Jan 29 '17