Forum Discussion
Subtotal Report Not Working
Hi Folks,
I am trying to use the Subtotal Report in Excel, assuming I have the right thing.
The data I have is very simple, in two columns. Column A is a list of names, and Column B is house points. As an example of the data, there are 10 rows with the same name in, but different house points in each row. I want to subtotal the points against each name.
I've run the report, and the subtotals I get are zero. I've set the change to be at the person's name, the function is Sum, and the subtotal is Points.
Any ideas what is wrong?
Thanks
CMSCMSCMS Fixed it. There was something odd about the point data. It had the green triangles in the top left corner, although despite a bit of googling I couldn't find any clear information about what they signify other than an error (but this is just numbers?!). I copied the numbers to notepad, then copied them to a new spreadsheet, and now it works.
3 Replies
CMSCMSCMS Fixed it. There was something odd about the point data. It had the green triangles in the top left corner, although despite a bit of googling I couldn't find any clear information about what they signify other than an error (but this is just numbers?!). I copied the numbers to notepad, then copied them to a new spreadsheet, and now it works.
Yes, that's only an alert says the values which looks like numbers are saved as text. You may select them and from the icon drop-down menu convert to numbers
