Useful excell/google sheets formulas

Sum all records except the first one in a column above the one that contains the formula:

=SUM(INDIRECT(ADDRESS(1;COLUMN())&":"&ADDRESS(ROW()-1;COLUMN())))

Calculate the percent of the main amount (E16) that's represents the sub ammount (J16) and add a percentage sign in the back:

=ROUND(J16*100/E16;2)&"%"

A nice way to increase an amount every month. Get the number of months after specific date and multiply them by 2000:

=(DATEDIF("15.05.2019"; TODAY(); "M")+1)*2000