search

legalese / legalese.github.io

Static assets for legalese.com
https://legalese.com/
70 stars 27 forks source link

Update Spreadsheets with better SUM formula #216

Open wtf opened 7 years ago

wtf commented 7 years ago

We should update all "amount raised" (and similar) formulas to =SUM(INDIRECT(ADDRESS(9,COLUMN())):INDIRECT(ADDRESS(ROW()-1,COLUMN()))) in all the spreadsheets we use.

This removes the need to update those formulas whenever we add new rows above it.

This update is required in order to properly resolve https://github.com/legalese/legalese.com/issues/73

NOTE: The starting row in the above formula is hard coded to 9 so it can be directly pasted into "amount raised" cells. Please use the correct starting row for other applications of the formula.