You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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 #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.
The text was updated successfully, but these errors were encountered:
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 #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.
The text was updated successfully, but these errors were encountered: