Forum Discussion
Sum help
Okay, I am trying to make a sheet to track PTO hours and add/sort them by the number of hours based on what kind of hours they are. Example, in one month, Suzy may have 3S, 5V, 7S, 5V, 5V. I am seeki...
Possible, but not very good practice. Please see attached, though slightly different from the solution you found yourself.
Agreed. A better option is to add the text through custom cell formatting. Standard SUM/SUMIF/SUMIFS, etc can then be used.
