Hi. Column A of a table has:
Travel
>aaa
>bbb
The values with the greater than symbol represent sub accounts. A problem came up when there is a SUMIF formula with column A as reference. It is reading the ">aaa" as greater than aaa.
How do I make the formula to read it as a plain character?
Thank you.