Forum Discussion

CMSCMSCMS's avatar
CMSCMSCMS
Iron Contributor
May 22, 2020
Solved

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 ...
Formulas and Functions
  • CMSCMSCMS's avatar
    CMSCMSCMS
    May 22, 2020

    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.

CMSCMSCMS's avatar
CMSCMSCMS
Iron Contributor
May 22, 2020

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.

  • CMSCMSCMS's avatar
    CMSCMSCMS
    Iron Contributor
    May 22, 2020

    CMSCMSCMS Apparently green triangles can signify numbers formatted as text, although I did change the formatting to numbers 🤷‍:male_sign:

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      May 22, 2020

      CMSCMSCMS 

      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

Resources