I need to pro-rate a dollar amount to number of attendees, however when I enter the formula in my spreadsheet and copy the formula down so when a new entry is recorded the formula is calculated several rows down the new record gets entered on the row after the last one the formula is in. How do you fix this?