Forum Discussion
summarize values by sum in Pivot table not working
working in pivot table and summarize values by sum is not working (the output is "0"), whilst summarizing by count gives an output of "682185"; this as the table is having so many lines. Any idea ho...
Please attach your sample file, not just a picture of your results.
The problem is exactly what the other respondents suspected. Your formula in the "Count" column (Col I) contains text. It uses the SUBSTITUTE function to create a text of the cells in the preceding columns.
What exactly is the result you expect to see in your column I ("Count")?