I have set up a formula that works very well however it isn't taking into account new entries added to my sheet. For example my formula is on Row 1 under the column 'total' I then have other information in rows 2-15 so therefore my formula on Row 1 starts from row 16 to give me the total I want into Row 1. My formula in row 1 is =SUM(total16:total18) this works fine for the data I have at the moment because I only have three lines of data (rows 16-18) however when I add in data to row 19 it obviously isn't included in the total in row 1. It wont allow me to make the formula open ended so that any new data is included in the formula. Any thoughts?
Many thanks, Irene