HI there, I have a question. In worksheets, is there way to calculate percentage of total? Say I have a name column (a, b, c), and I have number value column for them (10, 20, 30), can I create a third column to calculate the % of total for each name? Like a = 10/60, b = 20/60 etc?
Yes, you can do this by summing up your numeric column and then dividing each of your values by the total. For example, you can use a total column with the formula Sum([Value]), and then you can use this column to divide by all of your other values!